Table of Contents
Converting a time duration to minutes in Google Sheets involves using a simple formula. First, enter the time duration in the desired cell using the format “hours:minutes:seconds” (e.g. 1:30:00 for 1 hour and 30 minutes). Then, in a separate cell, use the formula “=HOUR(cell)*60+MINUTE(cell)” to convert the time duration to minutes. This will return the total number of minutes in the time duration. Make sure to format the cell as a number to display the result correctly. This method can be used for any time duration, regardless of the format.
Google Sheets: Convert Time Duration to Minutes
You can use the following formula to convert a time duration to minutes in Google Sheets:
=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 Google Sheets
Suppose we have the following dataset in Google Sheets 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 Format tab, then clicking Number, then clicking Duration:
We can then 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.
For example:
- A duration of 10 hours, 14 minutes, and 22 seconds is converted to 614.37 minutes.
- A duration of 26 hours, 14 minutes, and 22 seconds is converted to 15,74.37 minutes.
- A duration of 13 hours, 30 minutes, and 0 seconds is converted to 810 minutes.
And so on.
Note: This formula works because durations are stored as number of days in Google Sheets.
Thus, multiplying by 24 hours in a day and then by 60 minutes in an hour allows us to convert time durations to minutes.
Cite this article
stats writer (2024). How do I convert a time duration to minutes in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-convert-a-time-duration-to-minutes-in-google-sheets/
stats writer. "How do I convert a time duration to minutes in Google Sheets?." PSYCHOLOGICAL SCALES, 26 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-convert-a-time-duration-to-minutes-in-google-sheets/.
stats writer. "How do I convert a time duration to minutes in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-convert-a-time-duration-to-minutes-in-google-sheets/.
stats writer (2024) 'How do I convert a time duration to minutes in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-convert-a-time-duration-to-minutes-in-google-sheets/.
[1] stats writer, "How do I convert a time duration to minutes in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I convert a time duration to minutes in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.