IF Question

[Lisa]

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 End>Normal End,Actual End-Normal End,"") so that you can see how
much over your 'Normal Hours' you have worked that day?

 

[CLR]

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

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

Vaya con Dios,
Chuck, CABGx3

 

[Bob Phillips]

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)