Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an .xls file that contains Lat/Longs as well as a time stamp in this format:

hh:mm:ss AM/PM

When I create a feature class shapefile out of this .xls file, ArcMap reads it in and displays it fine, but the TIME field just shows 12:00:00 AM. What am I doing wrong here? I don't understand why ESRI makes it so difficult to do really simple things, like read in times correctly! Can anyone here show me the enlightened path to setting up my .xls properly or some other tricks that will enable me to enable the Time Slider feature?

Many thanks!

share|improve this question
up vote 2 down vote accepted

Formats Supported in ArcGIS 10.

hh:mm:ss AM/PM (A.M./P.M. not allowed!)

YYYY/MM/DD hh:mm:ss
YYYY-MM-DD hh:mm:ss
YYYY/MM/DD hh:mm:ss.s
YYYY-MM-DD hh:mm:ss.s



    YYYY = four-digit year
    MM = two-digit month (01=January)
    DD = two-digit day of month (01 through 31)
    hh = two digits of hour (00 through 23) (A.M./P.M. not allowed)
    mm = two digits of minute (00 through 59)
    ss = two digits of second (00 through 59)
    s = one digit of millisecond (0 through 9)

share|improve this answer
Thanks @Mapperz. So now I need to convert my 12-hour formats into 24 hour formats. I'll give it a shot and see what happens but from past iterations of this, ArcMap still converted it to 12:00:00 AM. I find it annoying/curious that AM/PM is not allowed, yet that is what's displayed as the "default" value if you end up importing "incorrectly". : – myClone Aug 24 '11 at 23:11

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.