I keep my pilot flight times in an excel spreadsheet.

The country in which I fly requires that I enter times in h:mm format. I have no trouble in summing the times in h:mm format, but cannot get the totals to display with the thousands separator for hours greater than 999:59.

Specifically, I want to display the “thousands” separator. Eg, my totals show as 15245:56 whereas I want to display as 15,245:56.

I’ve tried for days to use the custom number format to display the thousands separator in the h:mm format, but so far it eludes me.

Anyone know how to do this?