Formatting of hours in Excel spreadsheet
I keep my flight times in an excel spreadsheet.
The country in which I fly requires that I enter times in hh:mm format. I have no trouble in summing the times in hh:mm format, but cannot get the totals to display in the format that I want.
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.e hh,hhh:mm instead of hhhhh:mm.
I’ve tried for days to use the custom number format to display the thousands separator in the hh:mm format, but so far it eludes me.
Anyone know how to do this?