How to Convert Time to Decimal in Google Sheets

To convert time to decimal in Google Sheets, you can use a simple formula that multiplies the time value by 24, which is the number of hours in a day. This will give you the decimal value of the hours.

Follow these steps to convert time to decimal in Google Sheets:

  1. Open your Google Sheets document or create a new one.
  2. In a cell, enter the time you want to convert into decimal format. For example, let's say you want to convert the time "3:30:00" or 3 hours and 30 minutes to decimal. You would type "3:30:00" into cell A1.
  3. In the cell where you want the converted decimal value to be displayed, enter the following formula:

Replace "A1" with the cell containing the time you want to convert. In this example, the cell is A1.

  1. Press Enter. The time will be converted to a decimal, and the result will be displayed in the cell where you entered the formula.


Let's convert the time "3:30:00" to a decimal value.

  1. In cell A1, enter the time "3:30:00".
  2. In cell B1, enter the formula:
  1. Press Enter. The decimal value "3.5" will be displayed in cell B1, which represents 3 hours and 30 minutes in decimal format.
Did you find this useful?