My Excel operators are running a real-time itinerary process. I have designed dropdown lists for their convenience that names the times of the day in half-hour increments. But the operators are uncomfortable with the use of 24-hour military time, and this is the time value necessary for logging hours-worked from a bookkeeping perspective.
Is there a way in which the operator selects a familiar 12-hour (AM/PM) time from my dropdown list and have the selected cell automatically populate with a corresponding 24-hour-clock equivalent?
Cheers,
jeffery_g
Bookmarks