Convert 24 hours to 48 hours in excel

Hi,

How can i convert 24 hours timing to 48 hours. For example 01:00:05 should be displayed as 25:00:05 in excel.


Thanks in advance.

Hi Dhiraj,

Welcome to ExcelFox !!

Custom format the cell as

[h]:mm:ss

HTH

Worked for me.. Thank you very much.