When you right-click on one of the time cells and go to "format cells" what
is the category highlighted on the "number" tab? Does it say "time"? If not,
that may be your problem. Select "time" and then click on the correct option.
If not what happens if you change it to something else and click okay and
then go back and change it back to "time". Do the options then show you army
time with the colons?

"Liz J" wrote:

I'm looking at time data that is in army-time, but it does not have the
colons. So, the entire row has figures like this 2204, instead of 22:04.

Could you please help me to format this properly?

Thank you!