Article ID: 214122 - View products that this article applies to.
This article was previously published under Q214122
The following formula converts decimal minutes to the hh:mm:ss format in Microsoft Excel
=Minutes/1440where Minutes is a decimal number between 0.0 and 1440.0. The portion of the number to the left of the decimal refers to the number of minutes. The decimal portion of the number refers to seconds. As an example, 1439.0 minutes is equal to 23 hours and 59 minutes and converts to "23:59:00." There are 1440.0 minutes in 24 hours.
Using the formula shown above returns a serial number. To display the serial number in the appropriate format, follow these steps: