How to convert a number into hours in Google Sheets
google-sheets, google-sheets-formula
Solution
- Add up all the values using the function `=SUM(number1,number2,number3,number4,...)`. Example: `=SUM(A1:A200)` adds up all the numbers from A1, A2, A3 ... until A200.
- Divide the total number of hours (it's located in the field with the =SUM function) by 60 (60 minutes in 1 hour, of course) with `=DIVIDE(number1,number2)` Example: `=DIVIDE(A201,60)`. In case you put the `=SUM` function in field A201, you divide the result of that field by 60.
Problem
1950 minutes is 32.5 hours. How do I calculate this using a formula in Google Sheets? I am logging the number of minutes that I take on completing tasks and need a way of converting these numbers into the number of hours in Google Spreadsheets. I have a column that contains rows of minutes, 1 row per task. This sum total of this column then needs to be added together, then converted into hours.