Import Spreadsheet w Military Time into Access

In this Microsoft Access tutorial I'm going to teach you how to take a spreadsheet that has military times in it such as 1400 and 2230 and import those into Microsoft Access as proper time values. 

Samantha from Jacksonville, Florida (a Platinum Member) asks: I am using Microsoft Access and I have received a spreadsheet that has times in military format such as 1400 and 2230 and so on. Is there any way I can import this data into Access and convert those values into regular times in a date/time field?

Pre-Requisites

• Import Data: https://599cd.com/Import
• Military Time: https://599cd.com/MilitaryTime
• Format: https://599cd.com/Format
• String Functions: https://599cd.com/String
• Update Queries: https://599cd.com/UpdateQ
• DateSerial: https://599cd.com/DateSerial

Recommended Courses

• Access Expert 27: https://599cd.com/ACX27
• Access Expert 28: https://599cd.com/ACX28
• DateTime Seminar: https://599cd.com/DateTime

Formulae

• X: Format([MyTime],"0000")
• H: Left([X],2)
• N: Right([X],2)
• NT: TimeSerial([H],[N],0)

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, ms access import military time to date/time, excel 24 hour time to access, military time, date time, time values, time format, import Excel to Access, update query, time serial, query design, short text, join tables, date math