Creating formulas to calculate time on a 24 hr time clock

  • Thread starter Thread starter MWILLIAMS
  • Start date Start date
M

MWILLIAMS

I have to create a spreadsheet that will calculate total
hrs worked. I've tried several different ways but I guess
I don't know enough about building formulas to actually
make the thing work. For example, I used a basic formula
D3=A3-B3+IF(A3>B3,1)*12. This works to show the time but
not the number of hours worked. If an employee comes in
1/2 hour late, it does not properly calculate this. How
can I correct my formula?
 
MW

I have tried your formula and it works fine (with start time in B3 and
finish time in A3). Format the reult as h:mm and it's OK.

Andy
 
Back
Top