converting amount of seconds to mm:ss format

M

max em dancho

I have a small problem. I need to convert a number of seconds into
format mm:ss,ss. What would the formula be?

example: I need to convert 101,10 sec to 01:41,10

thanx in advance.
 
J

JE McGimpsey

One way:

XL stores times as fractional days, so you need to divide the number of
seconds by (24*60*60):

A1: 101,10
A2: =A1/86400

Format A2 as Format/Cells/Number/Custom mm:ss,00

You can do it in place by putting 86400 in a cell, copying the cell,
selecting your times and choosing Edit/Paste Special, selecting the
Values and Divide radio buttons). Format as above.
 

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

Converting :mm:ss to ss 8
How to convert 243 seconds to 4:03 (mm:ss) 2
Adding Time 7
How enter time DURATIONS mm:ss (not clock times), then sum? 1
how to convert whole numbers representing seconds to mm:ss 2
Converting Seconds to mm:ss format 3
Formating seconds into mm:ss 4
Convert seconds to mm:ss 2

Top