Thats awesome thank you
Thank you, actually our regular hours are 10 hours then anything over 10 is over time. However its a bit more tricky than that as well. i'll try to explain.
For the first 4 days of the week, the first 10 hours of each shift is regular time, then everything after that initial 10 is over time.
On the fifth shift of the week the first 4 hours of the shift is Reg time and then everything else is OT.
On the 6 and 7 shift of the week it straight overtime
eg.
Sunday 5:00 am-7:00 pm = 10 reg and 4 OT
Monday 5:00 am-7:00 pm = 10 reg and 4 OT
Tuesday 5:00 am-7:00 pm = 10 reg and 4 OT
Wednesday 5:00 am-7:00 pm = 10 reg and 4 OT
Thursday 5:00 am-7:00 pm =
4 reg and
10 OT
Friday 5:00 am-7:00 pm =
14 OT
Saturday 5:00 am-7:00 pm =
14 OT
I would gladly pay you if you can figure this out.
Start Time in Cell A2, Finish Time in Cell B2 and Assume Regular Time is 8 Hrs. Try below formula.
C2 Cell is Regular Time =IF(((B2-A2)*24)>8,8,((B2-A2)*24))
D2 Cell is Over Time =IF(((B2-A2)*24)>8,((B2-A2)*24-8))