Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Tuesday, 27 July 2021
  0 Replies
  2.4K Visits
0
Votes
Undo
i have a timesheet for work i need it to calculate total hours, overtime 1 and overtime 2
where hours from 07:00-15:00 is normal hours so no overtime counted
hours from 15:00-17:00 is counted in overtime 1
and all other hours is counted in overtime 2
like so
if A1(start time)=07:00 B1(end time)=19:00 C1(total hours)=12 D1(overtime1)=2 E1(overtime2)=2
or A1(start time)=04:00 B1(end time)=16:00 C1(total hours)=12 D1(overtime1)=1 E1(overtime2)=3

This is the formula i am using for overtime

 =IF(((C2-B2)+(E2-D2))*24>8, ((C2-B2)+(E2-D2))*24-8,0),
There are no replies made for this post yet.