Assuming you're entering hours and minutes (no seconds), convert with:
=time(a1/100,mod(a1,100),0)

Regards,
Fred

"ahdoj" wrote in message
...
I'm sure the answers here, but I can't sort it out.

I have data entered as general number with no punctuation that needs to be
converted to military time. How do I convert it without losing the time
entered?