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
format the cells as time type 13:30
which will change 01:00 pm to 13:00 24 hour clock format
select column with times...click format on tool bar
then click cells
then click the number tab
choose time from the menu
select 13:30 format
click ok
Last edited by martindwilson; 06-11-2009 at 07:23 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks