| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formating seconds into mm:ss
How do you format a cell to convert a "seconds" input into minutes and
seconds? Whenever I try to select the format mm:ss, it converts into a date with the month and year etc. Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formating seconds into mm:ss
If you have seconds as an integer in cell A1, put this in B1:
=A1/60/60/24 and apply a custom format to cell B1 of: [mm]:ss Times are stored internally in Excel as fractions of a 24-hour day, hence the need for those divisions. Hope this helps. Pete On Dec 14, 2:26*pm, Nelson B. wrote: How do you format a cell to convert a "seconds" input into minutes and seconds? *Whenever I try to select the format mm:ss, it converts into a date with the month and year etc. Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formating seconds into mm:ss
Hi,
I assume these 'seconds' are simply numbers so try this =A1/(60*60*24) Format as [mm]:ss Mike "Nelson B." wrote: How do you format a cell to convert a "seconds" input into minutes and seconds? Whenever I try to select the format mm:ss, it converts into a date with the month and year etc. Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formating seconds into mm:ss
Thanks for the help. This works, but I was hoping to be able to simply
change the format of a cell, so an input of 80 sec would show as 01:20. Is that possible or does it require the use of a formula? "Mike H" wrote: Hi, I assume these 'seconds' are simply numbers so try this =A1/(60*60*24) Format as [mm]:ss Mike "Nelson B." wrote: How do you format a cell to convert a "seconds" input into minutes and seconds? Whenever I try to select the format mm:ss, it converts into a date with the month and year etc. Thanks! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formating seconds into mm:ss
Hi,
I don't believe that is possible to do as a format. Mike "Nelson B." wrote: Thanks for the help. This works, but I was hoping to be able to simply change the format of a cell, so an input of 80 sec would show as 01:20. Is that possible or does it require the use of a formula? "Mike H" wrote: Hi, I assume these 'seconds' are simply numbers so try this =A1/(60*60*24) Format as [mm]:ss Mike "Nelson B." wrote: How do you format a cell to convert a "seconds" input into minutes and seconds? Whenever I try to select the format mm:ss, it converts into a date with the month and year etc. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change a minutes and seconds as a 2400 time to seconds? | Excel Worksheet Functions | |||
| Formula to Change Hours:Minutes:Seconds to Seconds only | Excel Discussion (Misc queries) | |||
| Converting Julian Seconds with a macro to replace old seconds data | Excel Discussion (Misc queries) | |||
| Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
| Convert seconds to minutes and seconds in excel | Excel Worksheet Functions | |||
Hybrid Mode
