| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert decimal days to Days,hours, minutes
Is there a way to convert decimal days to days:hrs:min.
So 1.5 would be "001:12:00" in the cell, 1 day , 12 hours or 0.25 would be "000:06:00" in cell, 6 hours thanks for your time |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert decimal numbers to a fraction of an hour for payroll hour | Excel Worksheet Functions | |||
| Need to convert hours and minutes to hours and tenths. | Excel Discussion (Misc queries) | |||
| convert decimal degrees to degrees minutes seconds | Excel Discussion (Misc queries) | |||
| Convert decimal degree (lattitude/longitude) into Degree, | Excel Discussion (Misc queries) | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Threaded Mode
