Merging Date and Time Fields in Access 2013

The date/time data type is simply a 64 bit floating point number under the skin, so all you have to do is add the values with [Admission Date]+[Admission Time] for instance.  While you can use the resulting value in calculations, you can easily create a new single column and insert the combined value into it with an 'update'query, e.g.

Update [YourTable]
SET [AdmissionDateTime] = [Admission Date]+[Admission Time]
[DischargeDateTime] = [Discharge Date]+[Discharge Time];

You can then remove the redundant columns from the table once you are staisfied that the results are correct.  But back-up the file first!

You might be interested in the file Timesheet.zip in my public databases folder at:

https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169

If you have difficulty opening the link copy its text (NB, not the link location) and paste it into your browser's address bar.

This little demo file includes a number of functions for doing date/time arithmetic where the result is 24 hours or more, which you cannot do directly by subtracting the date/time values.

While Ken's answer is correct, he is assuming that your 2 fields are Date/Time datatypes. If so, then do as he suggest. If not, we need to know what the datatypes for the 2 fields are.

Also if they are Date/Time types. I would suggest you run a query and format both fields as General Date. The date field should show the date with 00:00:00 as the time. The time field should show 12/30/1899 as the date. If these are not the case, then adding the two together will get inaccurate results.