Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula minutes and seconds
How do I change the following:
The cell reads: 14:42:0 for minutes and seconds. I need to convert cell to 14.7 -- John |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula minutes and seconds
Are you sure this is not hours:minutes:seconds? Usually you would have
14:42.0 if this stood for 14 minutes and 42 seconds (with no tenths of a second), but the way you have typed it it looks like 14 hours and 42 minutes. If it does stand for hh:mm:ss and you want the number of hours, then just multiply it by 24 and format the cell as a number with 1 decimal place. If it stands for mm:ss:tt with hours not displayed, then you will need to multiply by 24 and by 60 to convert it to decimal minutes. Hope this helps. Pete On Nov 21, 11:01 pm, John wrote: How do I change the following: The cell reads: 14:42:0 for minutes and seconds. I need to convert cell to 14.7 -- John |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula minutes and seconds
Hi,
Try =A1*60*24 Regards! Jean-Guy "John" wrote: How do I change the following: The cell reads: 14:42:0 for minutes and seconds. I need to convert cell to 14.7 -- John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering Seconds but displaying minutes & seconds | Excel Discussion (Misc queries) | |||
what is the formula to convert 5513 seconds into minutes 00:00:00 | Excel Worksheet Functions | |||
Formula to Change Hours:Minutes:Seconds to Seconds only | Excel Discussion (Misc queries) | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
Minutes and Seconds Formula | Excel Discussion (Misc queries) |