*29*

You can use the following formula to convert a time duration to seconds in Google Sheets:

**=VALUE(B2*24*3600)
**

This particular formula converts the time duration in cell B2 to seconds.

For example, if the time is **10:14:22**Â then the formula will convert this to **36862 **so that the time is represented as 36,862 seconds.

The following example shows how to use this formula in practice.

**Example: Convert Time to Seconds in Google Sheets**

Suppose we have the following dataset in Google Sheets that shows the number of hours, minutes, and seconds it took various athletes to finish a competition:

We can ensure that the values in the Duration column are formatted as durations by highlighting the range **B2:B11**, then clicking the **Format** tab, then clicking **Number**, then clicking **Duration**:

Â

We can then use the following formula to convert the durations into seconds:

**=VALUE(B2*24*3600)**

We will type this formula into cell **C2** and then click and drag the formula down to each remaining cell in column C:

The new **Seconds **column displays the time in the **Duration** column as seconds.

For example:

- A duration of 10 hours, 14 minutes, and 22 seconds is converted to
**36,862**seconds. - A duration of 26 hours, 14 minutes, and 22 seconds is converted to
**94,462**Â seconds. - A duration of 13 hours, 30 minutes, and 0 seconds is converted to
**48,600**seconds.

And so on.

**Note**: This formula works because durations are stored as number of days in Google Sheets.

Thus, multiplying by 24 hours in a day and then by 3,600 seconds in an hour allows us to convert time durations to seconds.

**Additional Resources**

The following tutorials explain how to perform other common operations in Google Sheets:

How to Convert Timestamp to Date in Google Sheets

How to Sort by Date in Google Sheets

How to Compare Dates in Google Sheets

How to Add Months to Date in Google Sheets