Roster

[Greg Brow]

I have asked this before but I am looking to have a spreadsheet that will
calculate the hours worked minus their meal breaks. I would like to do 2
things:

1st one is :

We work more than 5 hours we need to have a 30 minute meal break, If we
work more than 8 hours we have to have an hour.

Can i make a macro that will calculate this automatically.

part 2:

Is it possible to make excel not show the results unless the work times have
been inserted into cells b3 and c3.

Thanks in advance

Greg

 

[JE McGimpsey]

Not sure why you need a macro. A worksheet function works fine:


=IF(COUNT(B3,C3)<2,"",B3+C3-TIME(0,30,0)*((B3+C3)>5/24)

 

[JE McGimpsey]

Hit send by mistake...


=IF(COUNT(B3,C3)<2,"",B3+C3-TIME(0,30,0)*(((B3+C3)>5/24)+((B3+C3)>1/3)))

 

[RagDyer]

<"Hit send by mistake...">
Did you mean that literally John?
Do you have something on your keyboard that is "hittable?", that can
initiate a "send"?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Hit send by mistake...


=IF(COUNT(B3,C3)<2,"",B3+C3-TIME(0,30,0)*(((B3+C3)>5/24)+((B3+C3)>1/3)))

 

[JE McGimpsey]

Of course.

 

[Don Guillett]

I have one too

 

[JE McGimpsey]

I have one too

Doesn't everyone?

 

[George Gee]

I sold mine!

*JE McGimpsey* has posted this message:

 

[Ragdyer]

Besides taking the bait, you want me to also swallow the hook?<g>

 

[JE McGimpsey]

Besides taking the bait, you want me to also swallow the hook?<g>

Well, I do live in the middle of some of the best fly-fishing area in
the country...