In my excel file, I have columns of times that has always listed the data in a second format and nothing has ever been over 1 day until now. I was converting the cell to [h]:mm:ss;@ but if the seconds is equal to one day it lists the time as 0:00:00. I would like to be able to list the total hours:minutes:seconds so if it was 1 day 1 hour and 15 minutes and 22 seconds it would display as 25:01:15:22. Should I just store this is a text field, or is there a different cell format that I just dont see to show things in the complete hour format like I showed above?
Bookmarks