Number to time conversion
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?
|