| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert a number to a time
I have the following number 232.5 which is 232 hours and 0.5 of an hour. I
want to convert this to 232 hours and 30 minutes or 232:30. How can i do this? I know i need to multiply the decimal by 60, but how can i perform a calculation on just the decimal part of a number and not the whole number? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Convert to Number" option disappearing | Excel Discussion (Misc queries) | |||
| convert number to time format? | Excel Discussion (Misc queries) | |||
| how do i convert a number into minutes for a time of completion c. | Excel Discussion (Misc queries) | |||
| How do i convert a number of seconds to a date/time? | Excel Worksheet Functions | |||
| Convert week number into calendar month? | Excel Worksheet Functions | |||
Threaded Mode
