| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing decimal time into 24 hour time and reverse
Is it possible to change decimal time into 24hour time? For example, 1.75
hours in decimal in CELL A1 into 1:45 in 24 hour time in CELL B1. Also - how would I reverse it? For example 2:30 24 hour time into 2.5 decimal time. Also note that the decimal time would need to increment above 24:00 as the totals will be above this value Best Regards and thanks for looking. Bobzter |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to calculate time start & time finish in quarter hour | Excel Discussion (Misc queries) | |||
| Converting decimal time to standard time? | Excel Discussion (Misc queries) | |||
| convert decimal numbers to a fraction of an hour for payroll hour | Excel Worksheet Functions | |||
| making a time a measurement of time, not an hour of the day?? | Excel Discussion (Misc queries) | |||
| Convert decimal hour into time format? | Excel Discussion (Misc queries) | |||
Threaded Mode
