How to convert a number into hours in Google Sheets

Question

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.

Answer 1

1. 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.
2. 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.