Excel Formula Needed

  • Thread starter Thread starter hollistonit
  • Start date Start date
H

hollistonit

Our DPW director is looking for a formula that he can enter the date and
time that a plow driver started and the date and time that he ended and
have it give him the total hours worked
Thanks
 
With start time in A1 and finish time in B1, in C1 put = B1-A1

Format all cells as Time.

If you need to multiply this by an hourly rate, you will need to multiply the
value in C1 by 24, then by the hourly rate, eg in D1:-

=C1*24*Hrly_Rate
 
Our DPW director is looking for a formula that he can enter the date and
time that a plow driver started and the date and time that he ended and
have it give him the total hours worked
Click to expand...

Probably a formatting issue rather than a calculation one. Excel 'helpfully'
wraps all time calculations at multiples of 24 hours. To get the result as text,
try

=TEXT(EndDateTime-StartDateTime,"[h] ""hours and"" m ""minutes""")
 
One way:

A1: 9 December 2003 19:00
A2: 10 December 2003 03:00

A3: =A2 - A1 ===> 08:00

when formatted as time (Format/Cells/Number/Custom hh:mm).

XL stores times as fractional days, so if he wants integral hours,
the difference needs to be multiplied by 24 hrs/day:

A3: =(A2 - A1)*24 ====> 8
 
Back
Top