Change Time into Military

Hi all -

Looking for solution to a simple task. Using a form that shows date in this format: 8:00 AM, 9:30 AM, etc., Want to add a second column (that will be hidden from form) that changes this to military time. No calculations involved - only looking for the time conversion.

Yes, we could ask for military time in our form, but we want it to be quick and easy for our team members and not all are as versed in military time.

Thought about adding both options in the drop down (like 10:00 am/1000) and then parsing it out, but was hoping that someone may have a better suggestion.


Best Answers