How to Convert Time Duration to Seconds in Excel

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

1. 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.
2. In another cell (e.g., B1), enter the formula to convert the time duration to seconds:

=A1*24*60*60

3. 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.

1. Enter the time duration in cell A1: 01:15:30.
2. In cell B1, enter the formula to convert the time duration to seconds:

=A1*24*60*60

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