Convert Time to Minutes and Vice Versa in Excel

Add to Favorites

How to convert a time into minutes in Excel and also how to get minutes back into a time format. For instance, change "2:30" into 150 since there are 150 minutes in 2 hours and 30 minutes; then I'll show you how to change it back from 150 to "2:30".

Sections:

Time to Minutes

Minutes to Time

Notes

Time to Minutes

Change a time format into minutes like this:

=A1*24*60

21d0ada46d02cf4cc8838c56f4228889.png

Result:

d8b30373235ddb567e81fc32bdf7a279.png

Make sure that the cell that contains the minutes is formatted as General and NOT as a date or time.

0384884066350dc84dd67f74ed32577c.jpg

Minutes to Time

Change a time format into minutes like this:

=A2/24/60

e13dc4722e4972d3927dc66f34b4607f.png

Result:

f3f02fac8c60cc3e3cfa75ce30a653ae.png

Make sure that the cell that contains the time is formatted in a time format or you will see a decimal number.

For this example, right-click the cell (B2) and choose Format Cells and go to the Number tab and choose Custom and then h:mm from the list on the right.

471f29065fc4cc4f4d23c052eeb402fd.png

Notes

Remember that time is stored as a decimal. This is why we can use simple math to calculate the total minutes from a time-formatted number.

To learn more about dates and times in Excel, check out our Date/Time Tutorials for Excel.

Make sure to download the attached file to work with these examples in Excel.


Downloadable Files: Excel File

Similar Content on TeachExcel
Guide to Combine and Consolidate Data in Excel
Tutorial: Guide to combining and consolidating data in Excel. This includes consolidating data from ...
Make Negative Numbers Positive in Excel and Vice Versa
Tutorial: I will show you a few ways to change negative numbers to positive numbers and back again ...
Combine Data from Multiple Worksheets in Excel
Tutorial: The easiest way to combine and consolidate data in Excel. Simple method to combine data ...
Create and Manage Tables in Excel
Tutorial: Here, I'll show you everything you need to know to get started using tables in Excel; how...
How to Create and Manage a Chart in Excel
Tutorial: In this tutorial I am going to introduce you to creating and managing charts in Excel. Bef...
Filter Results in Excel to Show Only Those that End With Specified Text or Words - AutoFilter
Macro: This free Excel macro filters data to display results that end with certain words, text, o...