How to convert Time HH:MM:SS to Seconds & Seconds to Time HH:MM:SS in Excel
C:C shows the Formula used in B:B
| Time HH:MM:SS to Seconds | Formula | |
| 5:05:25 | 18325 | “=A2*86400” |
| Seconds to Time HH:MM:SS | Formula | |
| 18325 | 5:05:25 | “=A5/86400” |
How to convert Time HH:MM:SS to Seconds & Seconds to Time HH:MM:SS in Excel
