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.

Table of Contents hide

Download Practice Workbook

3 Simple Examples to Convert Seconds to Minutes in Excel

1. When Value Is Less Than 3600

2. When Value Is Between 3600 and 86400

3. When Value Is Greater Than 86400

Things to Remember

Conclusion

Download Practice Workbook

You can download the practice book from the link below.

Converting Seconds to Minutes.xlsx

3 Simple Examples 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. When 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.

Similar Readings

2. When 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.

3. When 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. For more queries, kindly visit our website ExcelDemy. Have a great day!