# Convert Time to Minutes and Vice Versa in Excel

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

Time to Minutes

Minutes to Time

Notes

## Time to Minutes

Change a time format into minutes like this:

``````=A1*24*60
``````

Result:

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

## Minutes to Time

Change a time format into minutes like this:

``=A2/24/60``

Result:

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.

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

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

#### Question? Ask it in our Excel Forum

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 (Multiple Methods)

• 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