LinkBack URL
About LinkBacks
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?
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?
cant u just convert the cell as text?
Please make the Post as solved, when you get your answer & Click * if you like my suggestion
Use a custom format:
[hh]:mm:ss
Everyone who confuses correlation and causation ends up dead.
You can try formatting the cell as [h]:mm:ss
See if this helps.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
That works! Thank you! What does the [] symbols mean?
It just allows the hours to extend past 24.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks