in a helper column:
=LEFT(A1,2)&":"&RIGHT(A1,2)
note, this turns it into a text so you can't do math on it anymore, and
times before 10 must be formatted 0904, etc

"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!