# 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:

- Open your Google Sheets document or create a new one.
- 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.
- In the cell where you want the converted decimal value to be displayed, enter the following formula:

`=A1*24`

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

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

## Example

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

- In cell A1, enter the time "3:30:00".
- In cell B1, enter the formula:

`=A1*24`

- 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?