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.
= Xn * (24 * 60)
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.
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)
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.