IF Question
 

If a normal working day is 8:00 AM - 5:00 PM and anything either over or
under that is counted as overtime, can I have one cell that tells me
=IF(Actual Start<Normal Start,Normal Start-Actual Start,"") and add
=IF(Actual EndNormal End,Actual End-Normal End,"") so that you can see how
much over your 'Normal Hours' you have worked that day?

With Ranges named ActualStart, ActualEnd, NormalStart, and NormalEnd, the
following will give you the overage in hours.

=IF((ActualEnd-ActualStart)*249,(ActualEnd-ActualStart)*24-9,0)

Vaya con Dios,
Chuck, CABGx3



"Lisa" wrote in message
...
If a normal working day is 8:00 AM - 5:00 PM and anything either over or
under that is counted as overtime, can I have one cell that tells me
=IF(Actual Start<Normal Start,Normal Start-Actual Start,"") and add
=IF(Actual EndNormal End,Actual End-Normal End,"") so that you can see
how
much over your 'Normal Hours' you have worked that day?

Normal hours

in C1: =MIN(B1,TIME(17,0,0)-MAX(A1,TIME(8,0,0)))

overtime hours

in D1; =MAX(0,B1-A1-C1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Lisa" wrote in message
...
If a normal working day is 8:00 AM - 5:00 PM and anything either over or
under that is counted as overtime, can I have one cell that tells me
=IF(Actual Start<Normal Start,Normal Start-Actual Start,"") and add
=IF(Actual EndNormal End,Actual End-Normal End,"") so that you can see
how
much over your 'Normal Hours' you have worked that day?