Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
converting time to decimals
Can anyone tell me how to convert a time format, such as 12:25 into a decimal
equivalent, in this case 12.416667, with the 25 seconds being .416667 of a minute. the time left in a ballgame for example might be 6:45. I'd like to convert this to 6.75. Thanks, Bob |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
converting time to decimals
Multiply it by 24
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "bob" wrote in message ... Can anyone tell me how to convert a time format, such as 12:25 into a decimal equivalent, in this case 12.416667, with the 25 seconds being .416667 of a minute. the time left in a ballgame for example might be 6:45. I'd like to convert this to 6.75. Thanks, Bob |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
converting time to decimals
Excellent. Thanks!
"Bob Phillips" wrote: Multiply it by 24 -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "bob" wrote in message ... Can anyone tell me how to convert a time format, such as 12:25 into a decimal equivalent, in this case 12.416667, with the 25 seconds being .416667 of a minute. the time left in a ballgame for example might be 6:45. I'd like to convert this to 6.75. Thanks, Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting time values | Excel Discussion (Misc queries) | |||
Convert Seconds and decimals to time | Excel Discussion (Misc queries) | |||
converting time worked to dollars earned. | New Users to Excel | |||
Time In Decimals | Excel Worksheet Functions | |||
Time - converting HH:MM:SS to Minutes | Excel Worksheet Functions |