Timesheet calculations

  • Thread starter Thread starter ladbrokejane
  • Start date Start date
L

ladbrokejane

I need to calculate the difference between start and finish times and show
the result as a decimal value so I can then apply a total monetary charge
rate.
I know how to calculate the result x hourly charge as long as the result
shows in decimal but I can only show the time difference as time.
e.g 11.45 to 13.30 = 1.45
I need to show it as decimal e.g. 11.45 to 13.30 = 1.75 so I can then
calculate that 1.75 x the hourly rate will be the charge
Help
 
Multiply the resulting difference by 24 and format as decimal.
In Excel date/time calculations, '1' represents a full day, so an hour is
1/24. Thus multiplying the time by 24 will give you the result in hours.
 
Back
Top