Microsoft Excel: Convert Seconds to HH:MM:SS Format

1. Open Microsoft Excel

2. Select cell B1, name it as seconds and in the cell B2 type the value to be converted to HH:MM:SS format.

3. Then select cell C1, name the cell as HH:MM:SS and paste the below formula in the cell C2.

=CONCATENATE(TEXT(TRUNC(B2/3600),"00"),":",TEXT(TRUNC(MOD(B2,3600)/60),"00"),":",TEXT(MOD(MOD(B2,3600),60),"00"))

4. And here is seconds converted to HH:MM:SS format. 

Thank you for reading my blog. !