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