Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Timesheet help | Excel Discussion (Misc queries) | |||
Timesheet | Excel Worksheet Functions | |||
Timesheet | Excel Worksheet Functions | |||
Timesheet calculations | Excel Worksheet Functions | |||
Timesheet Calculations | Excel Worksheet Functions |