| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to calculate time in 1/100 decimal while it is entered 1/60
Entering time in excel to create a time sheet 7.00am start 14.30 finish
would give a figure of 7.30 hrs as worked , actually 7.5 hrs is the hours worked. How does one achieve this answer |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
| How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
| How to type format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
| Convert time entered to decimal | Excel Discussion (Misc queries) | |||
| Employee schedule: I want it to calculate time entered such as 11. | Excel Discussion (Misc queries) | |||
Threaded Mode
