Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HH:MM:SS to decimal
I need to convert a time of more than 24 hours, like 37:45:00 to a decimal
value, 37.75, but don't know the proper function. Thanks in advance for your help! JTK |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HH:MM:SS to decimal
Multiply by 24.
Make sure you format the cell to General or Number. =A1*24 -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "John T Kennedy" wrote in message ... I need to convert a time of more than 24 hours, like 37:45:00 to a decimal value, 37.75, but don't know the proper function. Thanks in advance for your help! JTK |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HH:MM:SS to decimal
See answer elsewhere.
Pete On Dec 28, 4:51*pm, John T Kennedy wrote: I need to convert a time of more than 24 hours, like 37:45:00 to a decimal value, 37.75, but don't know the proper function. Thanks in advance for your help! JTK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert decimal commas to decimal points? | Excel Discussion (Misc queries) | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
Batch converting CSV files from comma-decimal to period-decimal | Excel Discussion (Misc queries) | |||
Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) |