Converting Seconds/Minutes to Minutes and Second (mm:ss) in Excel

Below is a screenshot of time in Second format and in Minutes format.

I'm going to show you to convert them into mm:ss format.

Second to MM:SS format:

First, we need to convert the second to day, there are 86400 seconds in a day. So, what we need to do here, is to divide Second with 86400.

After dividing second with 86400, we will get decimal value.

At the format panel in Home tab, click on More Number Formats...

Then select Custom > mm:ss format > OK.

We are done converting seconds into mm:ss format.

Minutes to MM:SS format:

Same goes with converting minutes to mm:ss format. There are 1440 minutes in a day, so divide minutes with 1440.

Then same step change the number format into custom mm:ss format.

There we go, we got the mm:ss time format.

Hope this simple article could help you in your data cleaning and data analysis. Like and follow if you want to learn more about Excel/Power Query/Power BI and more!