ExcelBanter - How to convert 243 seconds to 4:03 (mm:ss)

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to convert 243 seconds to 4:03 (mm:ss) (https://www.excelbanter.com/excel-worksheet-functions/182984-how-convert-243-seconds-4-03-mm-ss.html)

Jakeox

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.

Gary''s Student

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.

Jakeox

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.

All times are GMT +1. The time now is 10:03 PM.