Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
covert 72.8 to 72:48
what is the formula to convert a time that is hours and decimal of hours to
hours and minutes for instance 72.8 to 72:48 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
covert 72.8 to 72:48
On Tue, 10 Oct 2006 06:08:01 -0700, Rosemary
wrote: what is the formula to convert a time that is hours and decimal of hours to hours and minutes for instance 72.8 to 72:48 That depends on what you want to do with the value. Basically, you divide by 24 and format the result as Format/Cells/Number/Custom Type: [h]:mm That would give a value that Excel would recognize as time. You could also use the formula: =TEXT(A1/24,"[h]:mm") which would give a text string. --ron |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
covert 72.8 to 72:48
Rosemary,
If the value is in cell A1, use =A1/24 and format the cell with the formula for a custom number format of [h]:mm. HTH, Bernie MS Excel MVP "Rosemary" wrote in message ... what is the formula to convert a time that is hours and decimal of hours to hours and minutes for instance 72.8 to 72:48 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Covert text to Hyperlink | Excel Worksheet Functions | |||
How to covert picture excel format to editable excel format | Excel Discussion (Misc queries) | |||
covert Cellular phone dec to hex | Excel Discussion (Misc queries) | |||
How do I covert number format? | Excel Discussion (Misc queries) | |||
How to covert old Lotus 123 files with .123 extension to Excel? | Excel Discussion (Misc queries) |