Ticket #31484
Question
Numeric time field is not formatting properly. It shows for example in my report "1200:00" when I want it to be "12:00:00".
Answer
That Format Code to me that you took a screenshot of looks incorrect for your purposes. To resolve this issue, I would edit that Format Code (via the Admin Menu) and then recompile the report (no HTML overwrite is needed). When editing your Format Code the the letter associated to the format does not matter, however the format description should be "#:##:##" (without the " " marks).
Asked on May 13, 2021