payroll hours
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
|