how do I convert seconds to minutes:seconds

Question

Carrie Ward 20

I want to convert this number 261 seconds to minutes in this format but I can't remember how I did this :( User's image 12:04:21 AM

Accepted answer

1 additional answer

Answer 1

IlirU 331 Volunteer Moderator

User's image

Put the number in cell A2 and apply this formula:

=A2 / (24 * 60 * 60)

In Format Cell choose the Time (see the screenshot above).

Or you can use this formula which outputs the result as text but in time format:

=TEXT(A2 / (24 * 60 * 60), "hh:mm:ss AM/PM")

HTH.

Answer 2

HansV 460.6K MVP Volunteer Moderator

Let's say you have 261 in cell D2. In another cell, for example E2, enter the formula

=D2/86400

and format the cell with the formula as mm:ss or hh:mm:ss