How to Convert Decimal to Minutes and Seconds in Excel (3 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

Excel by default stores time in decimal format. But there are several ways by which we can convert it to hours, minutes, or seconds. Also, Excel has many built-in formats and custom formats to convert it to time. So, today I’ll show 3 easy methods to convert decimal to minutes and seconds in Excel.


How to Convert Decimal to Minutes and Seconds in Excel: 3 Ways

Let’s get introduced to our dataset first, It represents some workers’ working time in decimal format.


1. Manual Way to Convert Decimal to Minutes Only

First, we’ll learn how to convert decimal values to minutes only. Excel stores time as a fraction of one day. So, to convert to minutes you will have to multiply the decimal by 24hrs and 60minutes.

Steps:

  • Activate Cell D5 by clicking it.
  • Then, type the following formula in it-
=C5*24*60
  • Later, just hit the ENTER button and you will get the value as minutes.

Manual Way to Convert Decimal to Minutes Only

  • Finally, drag down the Fill Handle icon to copy the formula for the rest of the cells.

Manual Way to Convert Decimal to Minutes Only

All the decimal values are now converted to minutes.

Read More: How to Convert Number to Minutes in Excel


2. Manual Way to Convert Decimal to Seconds Only

In the same way, we can convert decimals to seconds only. For that, we’ll have to multiply the decimal by 86400. Because one day equals 24*60*60 = 86400 seconds.

Steps:

  • Insert the following formula in Cell D5–
=C5*24*60*60
  • Next, press the ENTER button to get the output.

Manual Way to Convert Decimal to Seconds Only

  • After that copy the formula for the other cells by dragging down the Fill Handle icon.

Manual Way to Convert Decimal to Seconds Only

Soon after you will get the values in seconds.

Read More: Convert Number to Military Time in Excel


3. Using Custom Format to Convert Decimal to Minutes and Seconds

Here, I have used a new dataset that contains some short films’ run time as minutes in number format. Now, we’ll convert it to minutes and seconds in time format. And for that, we’ll have to use a custom time format. First, we’ll convert the minutes to decimal and then will apply a custom format.

Steps:

  • In Cell D5, write the following formula-
=C5/(24*60)
  • Then hit the ENTER button.

Using Custom Format to Convert Decimal to Minutes and Seconds

  • Next, use the Fill Handle tool to copy the formula.

Using Custom Format to Convert Decimal to Minutes and Seconds

We got all the values as decimal, now we’ll apply a custom format.

Using Custom Format to Convert Decimal to Minutes and Seconds

  • Select all the converted decimal values and click the Number format icon from the Number section of the Home tab.

Soon after you will get the number format dialog box.

Using Custom Format to Convert Decimal to Minutes and Seconds

  • After that, click on the Custom
  • Then, write mm:ss in the Type box.
  • Finally, just press OK.

Now you see, the custom format has converted the values to time format as minutes and seconds.


Similar Readings


Download Practice Workbook

You can download the Excel workbook from here and practice on your own.


Conclusion

I hope the procedures described above will be good enough to convert decimal to minutes and seconds in Excel. Feel free to ask any question in the comment section and please give me feedback.


Related Articles

Md. Sourov Hossain Mithun
Md. Sourov Hossain Mithun

Hello! I am Md. Sourov Hossain Mithun. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is an amazing software to learn or work. Here, I will post Excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo