Sometimes combining Date and Time is not the best solution.
For example in this case it may be better to nominate a "day" as a date for the all the records coming from one sheet even though those after midnight are technically on the following day.
Then store the Time periods as integers, 1 to 24. They are discrete repeating times and as such don't really need to be held as time at all. They can easily be displayed as a real time if required.
The advantage of splitting the date and time becomes apparent if data from this table is displayed as a subform. The main form will have a day field (a date) allowing the MasterLinkFields to connect to the day field (also a date) in the subform.
With the date and time combined a complex calculation would be required to derive the ChildLinkField in the subform. Moreover this calculation would be required on every record in the table before the subform could display.
In the separated fields the "day" field in the subform recordsouce can be indexed making the process literally hundreds of times faster.