Hello,
I am having a hard time splitting this time stamp into two different columns. When I try to use the built in function it splits it into three columns: one for date, one for time, and another for AM/PM. After it does this it converts all of the times to AM. I've tried formatting the columns in advance but the GUI for splitting doesn't give me too many options as far as conversion. The original times are all in world(military) time, but excel converts them into standard(U.S.) time. I've tried writing a formula based on other threads I've seen concerning splitting cells but I end up with a fraction of a number, even when I try to tell it to output the data as a time or date. Any help would be much appreciated.
9/1/2013 19:00 this is what the cells look like but they convert to this 9/1/2013 7:00:00 PM when they are double clicked
Thanks in advance,
Ellsworth
Bookmarks