In order to bring consistency to one of our favorite websites, we created a form for the client to fill out for inputting new information. The website features different Tours, and departure and arrival times are key to the operation. We were getting inconsistent formatting in the times (2pm, 2PM, 2:00 PM, 2:00 AM, 2ish) and a typical Date/Time field didn't give us the programming functionality needed to automate other features of the website.
Who knew it would be so hard to Google a list of times for a dropdown menu? I share this list here for anyone else who was trying to find a simple list of times to include in a form! Copy/paste at will!
5 Different Time Choices to Choose From:
To combine any of these columns, copy/paste each set into ONE column in an Excel sheet. Then sort!
Paste into Notepad to keep the list format. Then paste into your website.
Need to include some HTML? Do a Replace-All in Notepad:
Replace with: AM <br><li>
Replace with: PM <br><li>