Show hh:mm:ss, when hh is > 24?

[OldManExcellor]

I want to display time as hh:mm:ss. This works if the total time is less than 24 hours. However with 25 hours it shows 01:00:00 instead of 25:00:00.

How can I change the format so that it shows 25 hours as 25:00:00?

[akhileshgs]

cant u just convert the cell as text?

[romperstomper]

Use a custom format:
[hh]:mm:ss

[sktneer]

You can try formatting the cell as [h]:mm:ss
See if this helps.

[OldManExcellor]

That works! Thank you! What does the [] symbols mean?

[romperstomper]

It just allows the hours to extend past 24.

[sktneer]

If that takes care of your question, please mark your thread as solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.