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