| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting a decimal time into hours and minutes
I need to convert the decimal time 24.72 into hours and minutes.
Obviously it's still 24 hours but I need to convert the .72 into minutes and rather than inputting the information each time I need to find a formula which will do it automatically. I've tried all the formulas and training sessions but they don't seem to work when it's over 24 hours. Thanks, Liz |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting decimal time to standard time? | Excel Discussion (Misc queries) | |||
| converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) | |||
| converting a decimal number to hours and seconds | Excel Worksheet Functions | |||
| adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
| Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
Threaded Mode
