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?