payroll hours

  • Thread starter Thread starter Donald
  • Start date Start date
D

Donald

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
 
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
 
Back
Top