# How to Convert Time to Minutes in Excel (5 Suitable Methods)

Get FREE Advanced Excel Exercises with Solutions!

Hour, minute, and second are the units of time. In different situations, we show time with the combination of these units. Such as HH:MM:SS, HH: MM, MM:SS, HH, SS, MM etc. In this article, we will show how to convert the time of any format to minutes in Excel.

Letâ€™s get introduced to our dataset first. In the following image, we represent time in two different formats.

Now letâ€™s explore the main discussion.

## 1. Convert Hours and Minutes in HH:MM Format to Just Minutes (Using Multiplication Factor)

In this section, our time is in HH:MM format. We will use a multiplication factor, i.e. 1440,Â  to convert the data to minutes.

The factor 1440 comes in this way.

1 day=24 hours

1 hour=60 minutes

Hence, 1 day=24 x 60, or 1440 minutes.

ðŸ“Œ Steps:

• First off, we add a new column on the right side. We will place the desired output in this new column.

• But before that, we need to change the value format of this column.
• To do that, select Range C5:C9.
• Then, press Ctrl +1.

• The Format Cells window appears here.
• Now, choose the Number category from the NumberÂ tab.
• Click the OK button finally.

• Now, move to Cell C5.
• Then, put the following formula on that cell.
`=B5*1440`

• Press the Enter button now.

We can see time is successfully converted to minutes.

## 2. Use Excel HOUR, MINUTE, and SECOND Functions to Convert Time to Minutes

In this section, we will use the combination of HOUR, MINUTE, and SECOND functions to convert the time of HH:MM:SS format time in Excel.

• The HOUR function returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.).
• The MINUTE functionÂ returns the minute, a number from 0 to 59.
• The SECOND function returns the minute, a number from 0 to 59.

If the sample time is in HH:MM or MM:SS format, we will customize the formula or can keep the formula as it is.

ðŸ“Œ Steps:

• Before we apply the formula, we change the format of the Total MinutesÂ column.
• Press Ctrl +1.

• From the Format Cells window, we fix 2 as the Decimal places.
• Then, click the OKÂ button.

• Now, put the formula on Cell C5.
`=HOUR(B5)*60+MINUTE(B5)+SECOND(B5)/60`

One thing that needs to mention is that we multiply the hour value by 60 and divide the second value by 60 to convert them into minutes. Lastly, add all the values.

• Finally, drag the Fill Handle icon after pressing EnterÂ button.

Here, we get the result in decimal format. A second is the fraction of a minute, which means if we convert seconds into minutes then decimal values will exist in minutes value.

## 3. Applying CONVERT Function

In this section, we will use the CONVERT function. The CONVERT function converts a number from one measurement system to another.

ðŸ“Œ Steps:

• First off, go the Cell C5 and put the following formula.
`=CONVERT(HOUR(B5),"hr","mn")+MINUTE(B5)+CONVERT(SECOND(B5),"sec","mn")`

We also use the HOUR and SECOND functions that extract the hour and second values from the given time and then apply the CONVERT function with those values.

• Press the Enter button and pull the Fill HandleÂ icon.

Finally, get the result after conversion.

## 4. Using TEXT Function to Convert Time to Minutes in Excel

The TEXT function converts a value to text in a specific number format.

In this section, we will use the TEXT function with a format to convert time to minutes.

ðŸ“Œ Steps:

• Now, go to Cell C5.
• Put the formula based on the TEXTÂ function.
`=TEXT(B5*1440,"0.00")`

• After pressing the Enter button and pulling the Fill HandleÂ icon.

Here, we multiply the time value by 1440 which is the conversion factor of day to minutes. Also, we add a decimal place as there is a second in the given time value.

Read More:Â How to Convert Time to Number in Excel

## 5. Converting Military Time to Minutes with Excel HOUR and MINUTE Functions

In this section, we want to convert military time to minutes. One interesting thing about military time is that there is no punctual mark between the hour and minute. Look at the dataset.

ðŸ“Œ Steps:

• Now, put the following formula on Cell C5.
`=HOUR(B5)*60+MINUTE(B5)`

• Then, press the Enter button and drag the Fill HandleÂ icon.

Military time is converted to minutes.

## More Examples of Converting Time to Minute in Excel

1. Conversion of Decimal Time to Hour and Minute

Here, we want to show how to convert decimal time to the hour and minute in Excel. In the following dataset, we have a set of times in decimal format.

ðŸ“Œ Steps:

• Now, go to Cell C5 and put the following formula.
`=B5/24`

• After pressing the Enter button, drag the Fill HandleÂ icon.

But the result has no meaning in terms of time value. We need to change the format of the cells.

• Select the Range C5:C9.
• Press Ctrl +1.
• The Format Cells window appears.
• Choose hh:mm format from the CustomÂ section.

• Finally, press OK.

We can see time is properly in hourly format.

Now, we will convert the decimal time into minutes.

• Go to Cell D5 and put the formula below.
`=B5/24*1440`

• Finally, press the Enter button and drag the Fill HandleÂ icon.

Decimal time has converted to hours and minutes successfully.

Read More: How to Convert Time to Decimal in Excel

2. Convert Date and Time Difference to Minutes

Itâ€™s time to think about the date. Here, we will find out the difference in date with time and convert that into minutes. We will use apply a simple subtraction and multiplication operation in this method.

We can see there are the start and end dates in our dataset.

ðŸ“Œ Steps:

• Now, go to Cell D5 and put the following formula.
`=(C5-B5)*1440`

• Then, press the Enter button and drag the Fill Handle icon downwards.

Finally, we get the result.

Read More: Convert Epoch Time to Date in Excel

## How to Convert Time to Hour and Second in Excel

Now, what if you need to convert time to hours and seconds too? In this section, we will show how to convert time to the hour and second units in Excel.

Here, we will use the combination of the HOUR, MINUTE, and SECOND functions to convert time to seconds.

ðŸ“Œ Steps:

• Just put the following formula on Cell C5.
Â  `=HOUR(B5)*3600+MINUTE(B5)*60+SECOND(B5)`

• Then, press the Enter button and pull the drag handle icon.

We get the result in the second format. We needed to apply a multiplication operation with the hour and minute values. Multiple hours by 3600 and minutes by 60.

We can easily convert this time format into hours.

• Put the modified formula on Cell C5.
`=HOUR(B5)+MINUTE(B5)/60+SECOND(B5)/3600`

• Again, press Enter and drag Fill HandleÂ icon.

Here we apply division operation with minutes and seconds.

Read More: How to Convert Time to Seconds in Excel

## Conclusion

In this article, we described how to convert time to minutes in Excel. We converted different formats of time into minutes. We also showed ways to convert times in other formats hours and minutes as well. I hope this will satisfy your needs. PleaseÂ give your suggestions in the comment box.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , and premium Excel consultancy services for Excel and business users. Feel free to contact us with your Excel projects.
Alok Paul

Hello, this is Alok. I am working as an Excel & VBA Content Developer at Exceldemy. I want to provide solutions to various Excel-based problems. I completed my study at East West University major in Telecommunications Engineering. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF