Convert seconds to minutes and seconds in excel

G

Guest

I need a formula which converts seconds to minutes and seconds.

TY for your help. Happy Holidays.

Chris
 
R

Ragdyer

This is for display only:
With seconds in A1:

=INT(A1/60)&" Min "&MOD(A1,60)&" Sec"
 
J

JE McGimpsey

XL stores times as fractional days, so to convert integer seconds to an
XL time (minutes and seconds), divide by 24*60*60:

A1: 123
A2: =A1/86400

which will display 2:03 when formatted as [m]:ss
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert text entered as minutes/seconds to minutes 1
How do I change a minutes and seconds as a 2400 time to seconds? 1
Convert Seconds to Minutes 11
Converting Decimal Degrees to Degrees/Minutes/Seconds 1
Summing minutes and seconds 2
Need to convert Minutes:Seconds format to minutes with seconds con 2
Degrees Minutes Seconds 3
Coverting seconds, to minutes and seconds 1

Top