Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Convert Seconds to Minutes in Excel

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.


Download Practice Workbook

You can download the practice book from the link below.


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.

Dataset for Converting Seconds to Minutes

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

Type Formula

 💡 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.

Enter Formula to Convert Seconds to Minutes

  • 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.

Format Cells Dialogue box to convert Seconds to Minutes

 ➡ 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.

Seconds to Minutes Converted

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

Convert Seconds to Minutes in Excel

Read More: Convert Seconds to Hours and Minutes in Excel (4 Easy Methods)


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.

Formula Applied to Convert Seconds to Minutes in Excel

  • 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.

Convert Seconds to Minutes in Excel when Value is between 3600 & 86400

 💡 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 (7 Easy Ways)


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.

A

  • 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.

Convert Seconds to Minutes When value is Greater Than 86400

 💡 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.

Read More: How to Convert Seconds to Hours Minutes Seconds in Excel


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!


Related Articles

Rafi

Rafi

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 worktime and made it easy for us to 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

Leave a reply

ExcelDemy
Logo