Menu
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.
396
Understanding this, you can convert a time to hours by multiplying the time by 24: When you multiply time by 24, Excel may format the result as time (ex. h:mm): To display the result as a regular number, change the formatting to General: All of the above examples work exactly the same in Google Sheets as in Excel.
As explained before, time in Sheets is technically a day unit, where 24 hours make up a full day. Press Enter. Sheets will now convert the time into minutes. You can also put hr or sec in place of min to convert the time into hours and seconds, respectively. Just like you converted time into minutes, you can also convert minutes into time.
You can use the following formulas to convert text to numbers in Google Sheets: The following examples show how to use each formula in practice. We can type the following formula into cell B2 to convert the text in cell A2 to a number: We can copy and paste this formula down to the remaining cells in column B:
You can use this time formula =if (B3<A3, (B3-A3+1)*24, (B3-A3)*24) to calculate night shift hours correctly in Google Sheets. What does this formula do? It also simply deduct the time in A3 from B3 as below and multiply by 24.
Here is a function that converts minutes in hour:minutes,
=if( A1 = 0 ; "" ; concatenate( quotient( A1 ; 60 ) ; ":" ;MOD(A1 ; 60) ))
62 --> 1:2
170
Use convert function to convert a numeric value to a different unit of measure
=CONVERT(A1; "mn"; "hr")
Documentation
20
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
