I have a custom format that I use on a daily basis.

I right click the cell/cells, select Format, and choose custom. Under Type, I enter 0":"00. If the time is 4:50 PM, I enter 450 and the cell formats it to 4:50. It looks like time, but to excel, it is still four hundred fifty. This makes it difficult if I want to calculate an average time.

Is there a way to create a custom cell format that when I enter 450, it formats it to time and 4:50. The spreadsheet is only used within a 12 hour basis, so AM and PM or military time is not necesarry.

I tried h":"mm, but that did not work.

Any ideas?