Help! I am not an excel power user. So I have a field that is standard time with AM/PM and would like to convert it to just military time. I have other fields where the time is in military time and need to look at Lapsed Times.
Originally, I had a date/time field mm/dd/yy hh:mm AM/PM. I extracted that data to a date field and a time field. Perhaps that wasn't the best way?
Thank you for your expert help.
Lonnie
Bookmarks