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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting a decimal time into hours and minutes
Hi
=24.72/24 , and format as some time format, p.e. "[h]:mm" Arvi Laanemets "LizHough" wrote in message ... 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 |
Reply |
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 |