G
Guest
I am having the worst time with a simple task. I have a field of numbers in
a table. That look like this:
94900
212252
212143
I want to convert them to military time.
9:49:00
21:22:52
21:21:43
what command does this, and can you provide an example. I have tried Cdate
and I get all 0's. I have tried Format but the digits get all off because of
one having a 1 digit hr.
Please help.
a table. That look like this:
94900
212252
212143
I want to convert them to military time.
9:49:00
21:22:52
21:21:43
what command does this, and can you provide an example. I have tried Cdate
and I get all 0's. I have tried Format but the digits get all off because of
one having a 1 digit hr.
Please help.