| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert decimal hours to time24hrs
Can someone please tell me how to convert a value formatted as a number and convert it to an hh:mm format (not in text)? eg. 78.73 hours to 78:44
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert time expressed as a decimal to actual hours or minu | Excel Worksheet Functions | |||
| Convert 29.08 hours (shown in decimal form) to time shown in "hh:m | Excel Worksheet Functions | |||
| How do I convert more than 24 hours time to decimal? | Excel Discussion (Misc queries) | |||
| Convert dd:hr:mn:ss to Decimal number of hours | Excel Discussion (Misc queries) | |||
| Convert Hours to Decimal | Excel Worksheet Functions | |||
Threaded Mode
