Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to convert 243 seconds to 4:03 (mm:ss)
I have over 5,000 values expressed in whole seconds in an Excel spreadsheet
and wish to convert them to mm:ss format. I cannot find how to do this in Excel or Office Help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to convert 243 seconds to 4:03 (mm:ss)
with 243 in A1, in B1 enter:
=A1/86400 and format B1 as m:ss -- Gary''s Student - gsnu200777 "Jakeox" wrote: I have over 5,000 values expressed in whole seconds in an Excel spreadsheet and wish to convert them to mm:ss format. I cannot find how to do this in Excel or Office Help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to convert 243 seconds to 4:03 (mm:ss)
"Gary''s Student" wrote: with 243 in A1, in B1 enter: =A1/86400 and format B1 as m:ss -- Gary''s Student - gsnu200777 "Jakeox" wrote: Perfect. Thanks for that. I have over 5,000 values expressed in whole seconds in an Excel spreadsheet and wish to convert them to mm:ss format. I cannot find how to do this in Excel or Office Help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert seconds to hh:mm:ss.dd ? | Excel Discussion (Misc queries) | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
convert to seconds | Excel Worksheet Functions | |||
Convert seconds to minutes and seconds in excel | Excel Worksheet Functions | |||
convert seconds to minutes and seconds | Excel Worksheet Functions |