In the above formula, we want to convert the number of minutes (15 in our case) to the number of hours. So, applying this formula to the time value in cell A2 shown below will give the result 4.258333333 Here we are assuming that the time value you want to convert is in cell A2. Once you have the number of hours, minutes, and seconds in a given time value, you can easily convert it to its decimal equivalent (in the number of hours) by using the following formula: =HOUR(A2)+MINUTE(A2)/60+SECOND(A2)/3600 You can also pass the numeric representation of the time. Here, time is a time value or a reference to a cell containing a time value. The syntax for the function is: =SECOND(time) For example, if you pass the time value “04:15:30” to this function, it will return 30, because there are 30 seconds in the time. This function takes in a time value and returns the second component of that value. The syntax for the function is: =MINUTE(time) For example, if you pass the time value “04:15:30” to this function, it will return 15, because there are 15 minutes in the time. This function takes in a time value and returns the minute component of that value. Interestingly, you can also pass the numeric representation of the time and you will still get the correct number of hours with this function. The syntax for the function is: =HOUR(time) For example, if you pass the time value “04:15:30” to this function, it will return 4, because there are 4 hours in the time. This function takes in a time value and returns the hour component of that value. Here’s what each of these functions does: Google Sheets lets you use three-time functions, HOUR, MINUTE, and SECOND. Method 1: Using Google Sheets Time functions (HOUR, MINUTE & SECOND) to Convert Time to Decimal Here are two ways to convert time to decimals.įor each method, we will show you how to convert time values to the number of hours, minutes as well as seconds, so you can apply the method as you need to. Two Ways of Converting Time to Decimal in Google Sheets: You May Also Like the Following Tutorials:.Method 2: Using Simple Multiplication with TIMEVALUE to Convert Time to Decimal in Google Sheets.Method 1: Using Google Sheets Time functions (HOUR, MINUTE & SECOND) to Convert Time to Decimal.Two Ways of Converting Time to Decimal in Google Sheets:.

Excel convert minutes into hours