Convert Time to Minutes and Vice Versa in Excel

Add to Favorites
Author:

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.

Question? Ask it in our Excel Forum


Downloadable Files: Excel File

Our Excel Courses

Professional Input Forms in Excel

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

Send Emails from Excel

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Convert Month Name to Number and Vice Versa in Excel
Tutorial: How to convert a month's name, such as January, into a number using a formula in Excel; al...
Guide to Combine and Consolidate Data in Excel
Tutorial: Guide to combining and consolidating data in Excel. This includes consolidating data from ...
Convert Time to Decimal - Hours, Minutes, Seconds
Tutorial: Easily convert time to decimal format so that 9:15 AM or 9:15 will become 9.25, which mean...
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...
Tutorial Details
Downloadable Files: Excel File
Similar Content
Convert Month Name to Number and Vice Versa in Excel
Tutorial: How to convert a month's name, such as January, into a number using a formula in Excel; al...
Guide to Combine and Consolidate Data in Excel
Tutorial: Guide to combining and consolidating data in Excel. This includes consolidating data from ...
Convert Time to Decimal - Hours, Minutes, Seconds
Tutorial: Easily convert time to decimal format so that 9:15 AM or 9:15 will become 9.25, which mean...
Excel Forum