How to convert a number into hours in Google Sheets

google-sheets google-sheets-formula
DigiKev picture DigiKev · May 3, 2012 · Viewed 33.9k times · Source

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

PierreLeroux picture PierreLeroux · May 8, 2014

Here is a function that converts minutes in hour:minutes,

=if( A1 = 0 ; "" ; concatenate( quotient( A1 ; 60 ) ; ":" ;MOD(A1  ; 60) ))

62 --> 1:2

Related questions

Conditional formatting based on another cell's value

I'm using Google Sheets for a daily dashboard. What I need is to change the background color of cell B5 based on the value of another cell - C5. If C5 is greater than 80% then the background color is green …

Read More
Count cells that contain any text

I want to count the cells that contain anything within a range. Any cell that contain text, or numbers or something else should do a plus one in my result-cell. I found this function, countif(range; criteria) but this doesn't …

Read More
Get the last non-empty cell in a column in Google Sheets

I use the following function =DAYS360(A2, A35) to calculate the difference between two dates in my column. However, the column is ever expanding and I currently have to manually change 'A35' as I update my spreadsheet. Is there …

Read More