How to Convert Minutes to Seconds in Excel (2 Quick Ways)

Get FREE Advanced Excel Exercises with Solutions!

Looking for ways to know how to convert minutes to seconds in Excel? We can convert minutes to seconds in Excel by going through some easy steps. You will find 2 ways to convert minutes to seconds in Excel here.


How to Convert Minutes to Seconds in Excel: 2 Quick Ways

Here, we have a dataset containing the Player Name and Swim Time in minutes of some swimmers. Now, we will show you how to convert minutes to seconds in Excel using this dataset.

Ways to Convert Minutes to Seconds in Excel


1. Using Arithmetic Formula to Convert Minutes to Seconds in Excel

In the first method, we will show you how to convert minutes to seconds using Arithmetic Formula in Excel. Follow the steps given below to do it on your own.

Steps:

  • Firstly, select Cell D5.
  • Then, insert the following formula.
=C5*60

Using Arithmetic Formula to Convert Minutes to Seconds in Excel

Here, as we know, 1 hour = 60 seconds so we multiplied Cell C5 by 60 to convert the time in minutes to seconds in Excel.

  • Next, press ENTER.
  • After that, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells.

  • Finally, you will get the values of time in minutes to seconds using the Arithmetic Formula in Excel.

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


2. Use of CONVERT Function to Convert Minutes to Seconds in Excel

We can also use the CONVERT Function to convert minutes to seconds in Excel. The CONVERT Function is used to convert the value of any data from one unit to another. To use this function, to convert time from minutes to seconds go through the following steps given below.

Steps:

  • In the beginning, select Cell D5.
  • After that, insert the following formula.
=CONVERT(C5,"mn","sec")

Use of Convert Function to Convert Minutes to Seconds in Excel

Here, in the CONVERT Function, we inserted Cell C5 as number, “mn” as from_unit and “sec” as to_unit.

  • Now, press ENTER.
  • Then, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells.

  • Finally, you will get the time values in minutes to seconds using the CONVERT Function in Excel.

Converting Minutes to Seconds in Excel Using CONVERT Function

Read More: How to Convert Seconds to Minutes in Excel


Applying HOUR, MINUTE and SECOND Functions to Convert Hours and Minutes to Seconds

Additionally, we will show you how you can convert hours and minutes to seconds by applying the HOUR, MINUTE, and SECOND functions in Excel.

Applying HOUR, MINUTE and SECOND Functions to Convert Hours and Minutes to Seconds

Follow the steps given below to do it on your own.

Steps:

  • Firstly, select Cell D5.
  • Then, insert the following formula.
=HOUR(C5)*3600 + MINUTE(C5)*60 + SECOND(C5)

Here, we inserted Cell C5 in the HOUR function and multiplied it by 3600 to convert it into seconds, then inserted Cell C5 in the MINUTES function and multiplied it by 60, and finally inserted Cell C5 in the SECOND function. At last, we added all the values to get the total value of time in seconds.

  • Next, press ENTER.

  • After that, to change the number format, select Cell D5.
  • Now, go to the Home tab >> select General from Number Format.

  • Then, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells.

  • Finally, you will get the values of time in hours and minutes to seconds using the HOUR, MINUTE, and SECOND functions in Excel.

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


Practice Section

In this section, we are giving you the dataset to practice on your own and learn to use these methods.

Practice Section


Download Practice Workbook


Conclusion

So, in this article, you will find 2 ways to convert minutes to seconds in Excel. Use any of these ways to accomplish the result in this regard. Hope you find this article helpful and informative. Feel free to comment if something seems difficult to understand. Let us know any other approaches which we might have missed here.


Related Articles


<< Go Back to Time Conversion | Date-Time in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Arin Islam
Arin Islam

Anowara Islam Arin, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Arin exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Besides, she is also interested in Advanced Excel,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo