# How to Convert Seconds to Minutes in Excel

Get FREE Advanced Excel Exercises with Solutions!

Microsoft Excel allows the user to convert different types of variables and terms into one another. You can perform time-zone conversion (i.e. GMT to EST), and time conversion (i.e. hours to minutes, minutes to seconds, etc., and vice versa) via this software. In this article, I will show you how to convert Seconds to Minutes in Excel.

In this section, you will find 3 easy and quick examples to convert seconds to minutes in Excel. I will discuss them one by one here with proper illustrations. Letâ€™s check them now!

## 1. Converting Seconds to Minutes in Excel (Value Is Less Than 3600)

Letâ€™s say, we have a dataset of some athletes participating in 3 different types of races and their corresponding time in seconds to finish the race.

Here, the time taken to finish the race is less than 3600 seconds. We want to convert the Seconds to Minutes. In order to demonstrate this method, proceed with the following steps.

Steps:

• First of all, create a new column for converting the seconds to minutes and type the following formula to the first cell of the newly created column.

`=D5/(60*60*24)`

Here,

• D5= Time in Seconds

Â ðŸ’¡ How the Formula Works

60*60*24=86400 Â is the number of seconds in a day. So, multiplying the seconds by 86400 returns a value with respect to the day. Changing the format to mm:ss will result in Minutes afterward.

• Then, press ENTER, and the cell will show the result value. As you havenâ€™t formatted the cell, it is formatted to General by default.

• Now, press CTRL+1 to open the Format Cells dialogue box.

Â âž¡ Note: You can also open the Format Cells dialogue box by right-clicking the mouse and selecting Format Cells from the options that appeared.

• Here, from the Number icon, go to the Custom option> select mm:ss in the Type field (or just type it)> click OK.

Â âž¡ Note: Here, mm stands for Minutes, and ss for Seconds.

• As a result, your cell will convert the value into Minutes.
• Now, drag the Fill Handle tool to Autofill the formula for the next cells in the column.

• Hence, you will get the output for all the cells.

## 2. Convert Seconds to Minutes (Value Is Between 3600 and 86400)

When your dataset got the values of seconds between the range 3600 and 86400, then you have to change the format for converting Seconds to Minutes.

To check out this method, follow the steps below.

Steps:

• Firstly, apply the formula stated in Method 1.

• Then, press CTRL+1 To open the Format Cells dialogue box> click Custom from the Number icon> select h:mm:ss from the Type field> click OK.

Â âž¡ Note: Here, h stands for Hour, mm for Minutes, and ss for Seconds.

• After that, drag the formula for the next cells to Autofill the formula.

• Hence, you will get the seconds converted.

Â ðŸ’¡ Reminder

Here, you should keep in mind that, if you want to calculate the Total Minutes, then you have to perform some calculations manually.

For example, Mike was in the race for 1:02:22 ( 1 hour 2 minutes 22 seconds).

Multiply the hours by 60 and then sum the result with the minutes.

So, Total Minutes= (1*60)+2= 62 Minutes.

Read More: Excel Convert Seconds to hh mm ss

## 3. Converting Seconds to Minutes (Value Is Greater Than 86400)

If you have got a dataset that includes time in Seconds that are greater than 86400, you have to just change the format.

In order to do so, just proceed with the steps below.

Steps:

• At first, apply the same formula stated in Method 1.

• Then, press CTRL+1 To open the Format Cells dialogue box> click Custom from the Number icon> type dd:hh:mm:ss from the Type field> click OK.

Â âž¡ Note: Here, dd stands for days, hh for Hours, mm for Minutes, and ss for Seconds.

• Now, drag the Fill Handle tool down to copy the formula for the next cells in the column.

• Finally, your cells will show the results.

Â ðŸ’¡ Reminder

Here, you should keep in mind that, if you want to calculate the Total Minutes, then you have to perform some calculations manually.

For example, Mike was in the race for 1:01:04:00 (1 day 1 hour 4 minutes 00 seconds).

Multiply the days by (24*60), hours by 60, and then sum the results with the minutes.

So, Total Minutes= (1*24*60)+(1*60)+4= 1504 Minutes.

## Things to Remember

• The range of seconds in which it has got value and format carefully.
• If want to get the total minutes and the value of seconds is greater than 3600, then calculate the total minutes manually after Formatting the cells.

## Conclusion

In this article, I have tried to show you some methods to convert Seconds to Minutes in Excel. I hope this article has shed some light on your way of time conversion in an Excel workbook. If you have better methods, questions, or feedback regarding this article, please donâ€™t forget to share them in the comment box. This will help me enrich my upcoming articles.

Have a great day!

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Rafiul Hasan

Hey there! I am Md. Rafiul Hasan. Currently, I am working as an Excel & VBA content developer. I like new ideas and want to explore the field of innovation. Excel has saved our work time and made it easy for us to perform quick calculations. I am trying to make it easier for you to overcome the obstacles you face while working on Excel. Stay connected!

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF