Queries :: Time Exports To Excel As 00/01/1900?

I am trying to export a table from access to excel. It has a couple of columns with times in and when excel opens it just shows 00/01/1900 for all the values.

Here is my query that creates the table for exporting:

Code:
SELECT tblRoadClosuresAdditionalDates.Reference, tblRoadClosuresAdditionalDates.DateOfClosure, CStr(Format([TimeFrom],"Medium Time")) AS TimeFromMod, TimeValue([TimeTo]) AS
TimeToMod, tblRoadClosuresAdditionalDates.NumberOfPeople INTO tmpAdditionDates
FROM tblRoadClosuresAdditionalDates
WHERE (((tblRoadClosuresAdditionalDates.Reference)=[Forms]![frmProgressRoadClosures]![sfrmRoadClosuresAdditionalDates].[Form]![Reference]));

You can see a couple of my attempts to handle this data above.

I am using this code to create my excel table.

Code:
DoCmd.OpenQuery "qryRCADditionalDatesFilteredExport"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "tmpAdditionDates", "xxxxxxxxxxxxxx", No

way to handle this field so that I get just the time in the medium time format appearing in the excel table.