I received a list of numbers in Custom format (Type: 000000) that represent military time. It always contain 6 digits, and leading zeros are used when necessary. For example:
- 123456 becomes 12:34:56 (pm)
- 000321 becomes 00:03:21 (am)
- 142321 becomes 14:23:21 (pm)
How do I convert the integers in Column A into the format in the Column B (hh:mm:ss)? I'd like to use military, 24-hr clock.
See Question&Answers more detail:os