The Most Effective Method to Convert Time to Decimal in Google Sheets ( Easy Guide)

In this tutorial, we will learn, How to Convert time to decimal in Google Sheets.

If your data set contains date and time values, there may be circumstances where you want to switch them over entirely to decimal numbers. For instance, you should change the distinction between the beginning and end season of a specific undertaking into a decimal number.

How to Convert Time to decimal in Google Sheets

TWO WAYS OF TRANSFORMING TIME TO DECIMAL IN GOOGLE SHEETS:

The following are two methods for changing time over completely to decimals. For every technique, we will tell you the best way to change time values over entirely to the figure of hours, minutes, and seconds so you can apply the strategy as the need might arise.

Technique 1: Using Google Sheets Time capacities (HOUR, MINUTE, and SECOND) to Convert Time to Decimal

Google Sheets allows you to utilize three-time capacities, HOUR, MINUTE, and SECOND. Every one of these capacities does this:

THE HOUR FUNCTION

This capacity requires some investment worth and returns the hour part of that worth. For instance, assuming you take a break esteem “04:15:30” to this capacity, it will return 4, since there are 4 hours in the time. The punctuation for the capacity is:=HOUR(time)

Here, time is period esteem or a reference to a cell containing period esteem. You can likewise pass the numeric portrayal of the time, and you will, in any case, get the correct number of hours with this capacity.

THE MINUTE FUNCTION

This capacity requires some investment worth and returns the moment part of that worth. For instance, assuming you breathe easy worth “04:15:30” to this capacity, it will return 15 since there are 15 minutes in the time. The sentence structure for the capacity is:=MINUTE(time)

Here, time is period esteem or a reference to a cell containing period esteem. You can likewise pass the numeric portrayal of the time.

THE SECOND FUNCTION

This capacity requires some investment worth and returns the second part of that worth. For instance, assuming you take a break esteem “04:15:30” to this capacity, it will return 30 since there are 30 seconds in the time. The punctuation for the capacity is:=SECOND(time)

Here, time is period esteem or a reference to a cell containing period esteem. You can likewise pass the numeric portrayal of the time.

Strategy 2: Using Simple Multiplication with Time Value to Convert Time to Decimal in Google Sheets

  • One more technique utilizes essential duplication of the time esteem with the number of hours, minutes, and seconds in a day.
  • Time values in Google Sheets are put away inside as decimal qualities, where 24 hours are addressed with the worth 1.0.

In this manner, to manage 60 minutes, we utilize the worth 1/24. Thus, to switch the time esteem over entirely to a decimal using this technique, we want to initially get hold of its interior worth utilizing the Time Value work.

THE TIME VALUE FUNCTION

  • This capacity requires some investment worth and returns as a negligible portion of a 24-hour day. For instance, if you relax esteem “12:00:00” to this capacity, it will return 0.5 because 12 hours is a portion of a day.
  • Essentially, on the off chance that you relax esteem “06:16:00” to this capacity, it will return 0.2611111111, which is near 0.25, because 6 hours 16 minutes is correct for around a fourth of a day. The sentence structure for the capacity is:=TIMEVALUE(time_string).

How to Convert Time to decimal in Google Sheets: CONCLUSION

This can go about as a mark of the number of hours worked. It is instinctive to say that one worked for 4.25 hours instead of 4:15 hours. Likewise, it helps to assume you want to involve the distinction esteem in different estimations accordingly.

We hope this tutorial on How to Convert Time to decimal in Google Sheets was useful.