Using military time, how do I create a formula that totals the hours as
10 being regular hours 10 to 12 being OT and 12 and beyond as double
time, with a half hour taken out for lunch.

in time out time reg OT DT

2000 0930 10 2 1


--
Donald
------------------------------------------------------------------------
Donald's Profile: http://www.excelforum.com/member.php...o&userid=15171
View this thread: http://www.excelforum.com/showthread...hreadid=492991