# How to Convert Time Duration to Seconds in Excel

To convert time duration to seconds in Excel, follow these steps:

- Enter the time duration in one cell (e.g., A1) in the format:
`hh:mm:ss`

. For example, if the duration is 2 hours, 30 minutes, and 45 seconds, you would enter`02:30:45`

in cell A1. - In another cell (e.g., B1), enter the formula to convert the time duration to seconds:

`=A1*24*60*60`

- Press Enter to get the result. In this case, cell B1 will display the total number of seconds for the time duration entered in cell A1 (e.g., 9045 seconds).

## Example

Let's assume you want to convert the time duration of 1 hour, 15 minutes, and 30 seconds to seconds in Excel.

- Enter the time duration in cell A1:
`01:15:30`

. - In cell B1, enter the formula to convert the time duration to seconds:

`=A1*24*60*60`

- Press Enter, and you'll get the result in cell B1:
`4530 seconds`

.

Did you find this useful?