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

Hi Donald

With Time in in A, and Time out in B

C1=MIN(10,((MOD(B2-A2,1)-TIME(0,30,0))*24))
D1=MIN(2,(((MOD(B2-A2,1)-TIME(0,30,0))*24)-10))
E1=((MOD(B2-A2,1)-TIME(0,30,0))*24)-D2-E2
Format cells C1:E1 as General

Regards

Roger Govier


Donald wrote:
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