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”