Hi!

A1 = start time = 18:00
B1 = end time = 4:00

For Reg hrs:

=IF(COUNT(A1:B1)<2,"",IF(B1<A1,(1-A1)*24,(B1-A1)*24))

For OT hrs:

=IF(COUNT(A1:B1)<2,"",IF(B1<A1,B1*24,0))

Biff

"Sasha" wrote in
message ...

Hi,

I am trying to make time sheet that would forecast employment cost.
Payment criteria is that overtime applies after midnight.
Sheet that I've designed has four columns per day IE. start & finish
time for AM shift IE. (08:00 - 16:00) and start and finish for PM
shift. That could be (17:00 - 23:00), which doesn't create problem so
far but when inputting something like (18:00 - 04:00) i get total hours
worked. What sort of formula should I use that would separate basic
hours from overtime hours automatically IE. (6hrs basic and 4hrs
overtime).

Any help on this matter would be greatly appreciated :)


--
Sasha
------------------------------------------------------------------------
Sasha's Profile:
http://www.excelforum.com/member.php...o&userid=36608
View this thread: http://www.excelforum.com/showthread...hreadid=563527