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.
|