subtracting time

  • Thread starter Thread starter Russ
  • Start date Start date
Russ said:
I need the formula to find total time on job. Arrive 9:30
AM leave 12:45 PM and so on

If 9:30 is in A1 and 12:45 in A2, the the formula
=A2-A1
will give 3:15

You may need to format appropriately.

If you want the actual number of hours as a number for further calculations
(i.e. in this case 3.25), multiply by 24 (and format as number or general).
 
Back
Top