| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Minutes to Seconds
Example;
Cell reads 114.4 Need to convert to 74.4 Seconds. Any thoughts? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Minutes to Seconds
With
A1: 114.4 If I understand correctly....try this: B1: =INT(A1/100)*60+MOD(A1,100) Does that help? *********** Regards, Ron XL2002, WinXP "M.A.Tyler" wrote: Example; Cell reads 114.4 Need to convert to 74.4 Seconds. Any thoughts? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Minutes to Seconds
If the A1 had been entered as 1:14.4, you could use =A1*24*3600 (and format
as number or general). -- David Biddulph "Ron Coderre" wrote in message ... With A1: 114.4 If I understand correctly....try this: B1: =INT(A1/100)*60+MOD(A1,100) "M.A.Tyler" wrote: Example; Cell reads 114.4 Need to convert to 74.4 Seconds. Any thoughts? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering Seconds but displaying minutes & seconds | Excel Discussion (Misc queries) | |||
| Formula to Change Hours:Minutes:Seconds to Seconds only | Excel Discussion (Misc queries) | |||
| Converting hours:minutes:seconds to just minutes | Excel Worksheet Functions | |||
| Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
| Convert seconds to minutes and seconds in excel | Excel Worksheet Functions | |||
Linear Mode
