Fresh Excel Tips

In this example, we have time in one column (A) and the converted values in minutes in a next column (B). The time is in a hours and minutes format, example 13:56 or 3:10. Here is how we achieve this task.

How to convert time in Hours and minutes to minutes only.

1. Open up Microsoft Excel. This formula should work in virtually any version of Excel including 97, 2003 and 2007
2. For this example, we will assume that the times are listed in cells A5:A10.
3. Select Cells B5:B10.
4. Enter the following formula: =A5*24*60.
5. Press CTRL+Enter
6. Format the cells B5:B10 by selecting the Format Menu and choosing Cells and General, the Click Ok.

To convert the minutes back to Hours and minutes format, use the formula =A5/24/60. Remember to format the cells with a time format to achieve the desired effect. That’s it!

1. How to Use the HOUR function to calculate with 100-minute hours
2. How to Use the ROUND function to round time values to whole minutes
3. How to Convert Currencies in Excel
4. How to Use the TIMEVALUE function to convert text to time
5. Convert negative values to positive using Excel