Forum Discussion
Formatting / Inputting Help Needed
If this is just for display purposes, you can apply the custom number format 00\:00\:00 to the column with the run times.
The run times will still be stored as 12345 etc., so you won't be able to use them in calculations such as totaling, at least not easily.
As an alternative, you can use VBA code (in the desktop version of Excel for Windows and Mac) to convert 12345 to the time value 01:23:45 automatically - see Date and Time Entry (this is an old website that does not use https:// but it is safe)
If this is just for display purposes, you can apply the custom number format 00\:00\:00 to the column with the run times.
The run times will still be stored as 12345 etc., so you won't be able to use them in calculations such as totaling, at least not easily.
As an alternative, you can use VBA code (in the desktop version of Excel for Windows and Mac) to convert 12345 to the time value 01:23:45 automatically - see Date and Time Entry (this is an old website that does not use https:// but it is safe)
That did it! Thanks so much!