converting amount of seconds to mm:ss format

  • Thread starter Thread starter max em dancho
  • Start date Start date
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.
 
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.
 
Back
Top