Excel Text to columns changing 24 clock time to 12 hr clock. - TechRepublic
Question
October 9, 2008 at 12:11 PM
malibooboo

Excel Text to columns changing 24 clock time to 12 hr clock.

by malibooboo . Updated 15 years, 7 months ago

I am trying to do a text to column split of a column containg time in a 24 hour clock format (ex 13:15) but Excel keeps changing the 13:15 for exampke to 1:15. In otherwords, it changes everything to a 12 hour clock. I hasve tried forecing leading zeros, placing ” ’00:00 ” in the custom formatting etc. Help! I need numbers to stay in teh 24 hour format.

This discussion is locked

All Comments