Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I want to be able to convert a decimal into time, and am completely stuck!
As an example, I have in cell A1 4.9 (this number represents 4.9hrs). I want a formula that will calculate the hours and minutes for me, and show the result in normal time format. In my example above the answer I would be looking for is 04:54 (i.e. four hours and 54 minutes). I have trawled these threads and have found many posts on how to convert time to a decimal. I want to do the reverse. Any ideas? Darrell. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting a decimal time into hours and minutes | Excel Worksheet Functions | |||
Converting a decimal number into time | Excel Discussion (Misc queries) | |||
Converting decimal time to standard time? | Excel Discussion (Misc queries) | |||
Converting decimal to time | Excel Discussion (Misc queries) | |||
Converting Decimal to Time | Excel Discussion (Misc queries) |