Question Locked

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

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

4 replies

by tgullo

The fact that excel keeps changing it to 12 hr time means that the conversion is working and therefore you can simply use a custom format of h:mm in the custom format area.

But you could use the standard time format option of 24 hr clock in TIME format area. This however will default to hrs, mins & secs in 24 hr mode.

This discussion is closed to new replies.