Thanks Biff,

Formulas work very well, thanks
the only time problem occurs is when shift starts at midnight
IE (00:00 - 05:00) formula calculates all the time as basic when it
should be overtime (any hours done after midnight).

Any ideas?

Thanks,
Sasha


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