how to convert whole numbers representing seconds to mm:ss

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how can i convert in excel whole numbers (ex 234) representing seconds to mm:ss
 
hi!

try this!!

=TEXT(A1/86400,"mm:ss")

assuming your number is in A1

-via135
 
You must log in or register to reply here.

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

How to convert 243 seconds to 4:03 (mm:ss) 2
Summing minutes and seconds 2
text in mm:ss to time 5
Time difference function 14
Converting :mm:ss to ss 8
Converting Seconds to mm:ss format 3
How enter time DURATIONS mm:ss (not clock times), then sum? 1
Adding Time 7

Back
Top