Table of Contents
To convert a time duration to minutes in Excel, you can use the built-in function “MINUTE”, which will return the number of minutes in a given time value. This function can be used in a formula, where the time duration is entered as a cell reference or a specific time value. By multiplying the result of the “MINUTE” function by 60, the time duration will be converted to minutes. This is useful for calculating billable hours, tracking project timelines, or any other time-based calculations. Additionally, Excel also offers various formatting and conversion options for displaying the converted time duration in minutes. By utilizing these features, converting a time duration to minutes in Excel can be done quickly and accurately.
Excel: Convert Time Duration to Minutes
You can use the following formula to convert a time duration to minutes in Excel:
=VALUE(B2*24*60)
This particular formula converts the time duration in cell B2 to minutes.
For example, if the time is 10:14:22 then the formula will convert this to 614.37 so that the time is represented as 614.37 minutes.
The following example shows how to use this formula in practice.
Example: Convert Time to Minutes in Excel
Suppose we have the following dataset in Excel that shows the number of hours, minutes, and seconds it took various athletes to finish a competition:
We can ensure that the values in the Duration column are formatted as durations by highlighting the range B2:B11, then clicking the Number Format dropdown, then clicking More Number Formats:
We can then click the Category on the left called Custom, then choose h:mm:ss, then click OK:
Next, we can use the following formula to convert the durations into minutes:
=VALUE(B2*24*60)We will type this formula into cell C2 and then click and drag the formula down to each remaining cell in column C:
The new Minutes column displays the time in the Duration column as minutes.
- A duration of 10 hours, 14 minutes, and 22 seconds is converted to 614.3667 minutes.
- A duration of 26 hours, 14 minutes, and 22 seconds is converted to 1,547.367 minutes.
- A duration of 13 hours, 30 minutes, and 0 seconds is converted to 810 minutes.
And so on.
Note: In this formula we multiply the time durations by 24 hours in a day and then by 60 minutes in an hour allows us to convert time durations to minutes.
The following tutorials explain how to perform other common operations in Excel:
Cite this article
stats writer (2024). How can I convert a time duration to minutes in Excel?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-convert-a-time-duration-to-minutes-in-excel/
stats writer. "How can I convert a time duration to minutes in Excel?." PSYCHOLOGICAL SCALES, 26 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-convert-a-time-duration-to-minutes-in-excel/.
stats writer. "How can I convert a time duration to minutes in Excel?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-convert-a-time-duration-to-minutes-in-excel/.
stats writer (2024) 'How can I convert a time duration to minutes in Excel?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-convert-a-time-duration-to-minutes-in-excel/.
[1] stats writer, "How can I convert a time duration to minutes in Excel?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I convert a time duration to minutes in Excel?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.