I have a spreadsheet in Excel that has two times (start & stop times). They are formatted with the TIME 13:30 format in Excel. When I copy the spreadsheet into Access, only some of the records copy for the start/stop times (it is just the start/stop times that are not copying over for some records...everything else copies just fine)
In the db I have set the Date/Time to Short Time.
I think it is because some of those records have the time of 24:00...we have 24 hour shifts, the way our payroll shows it as shift ends at on day 1 at 24:00 and starts at 00:00 on day 2...how can I format that start/stop time field to accept the 24: ?