< Go Back

Convert Excel time to decimal minutes

Microsoft Excel follows some standards of date and time. For example, in Excel on the 24-hour day is equal to 1 unit of time. In order to convert Excel time in standard minutes, it is to be multiplied with a factor to convert it into standard minutes.

Convert Excel Time to Decimal Minutes

In order to convert Excel time to decimal minutes, the one unit of Excel time, i.e. 24 hours is needed to be multiplied by a fixed factor.

Formula

= Xn * (24 * 60)

Explanation

For instance, 1:00 AM is 1/24th (=0.04167) part of a day.

Because each hour is equal to 1/24, and for conversion to decimal minutes by multiplying the value by 1440 i.e. 24*60.

Microsoft Excel has many built-in data validation rules for numbers. This article explains that how to set the data validation to allow numbers only, in the cell. To allow only the numbers in a cell, you can use the data validation option by setting it to the custom option based on providing the ISNUMBER function for that specific cell.

In the example presented below, data validation is applied to some cells B2:B7.

Example 1

With that, 1:00 AM can be converted into minutes as follows:

If any cell Xn, e.g. C4 contains a value: 1:00 AM then it can be converted into minutes by adopting the following procedure:

= C4* (24 * 60)

= (1 / 24) * (1440)

= 0.04167 * 1440

= 60 minutes

This procedure is quite simple and can be done by just a few arithmetic operations. Step by step procedure to convert time into minutes is described in the following examples.

A list of standard time hours is shown in the following figure that has been entered manually. In order to see the corresponding excel time, each hour is multiplied with 1/24 i.e. 1 unit is equal to 24 hours.

Figure 1. Sample sheet for converting Excel time in decimal minutes by multiplying time column (B) with 1440 (Number of minutes in a day = 24×60)

Example 2

Similarly, 4:00 AM can be converted into minutes as follows:

If any cell Xn, e.g. A2 contains a value: 4:00 AM then it can be converted into minutes by adopting the following procedure:

= A2* (24 * 60)

= (4 / 24) * (1440)

= 0.167 * 1440

= 240 minutes.

In order to do this in excel, the desired cell can be selected and if it’s containing the Excel time it must be multiplied by 1440 that will give time in decimal minutes.

 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar