The form I'm using does have a cell for the date that the overtime is
worked. The formula I'm using does not reference that cell.

If the date cell was included in the formula, is there a way the time
calculation can be changed to reflect 24 hours instead of 0?

Thanx

JF


--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=477255