truncate date not time

[buckwheat]

I have a database that pulls in actual trailer arrivals as a date/time value. I also have a table that has the scheduled arrival time by just the time of day without a date. I need to calculate how late the trailer arrivals are. Is there a way to truncate the date and just calculate the time? Example

Field A
11/02/2005 13:00
Field B
12:00

Field A - B should result in 1:00

I would also like to display Field A as 13:00

Thanks in advance.

 

[meloncolly]

try

SELECT timevalue(format(hour([fieldA]),"00") & ":" & format(minute([fielda]),"00")) as ActualArrival, [your planned arrival field] as PlannedArrival, (datediff("h",[ActualArrival],[PlannedArrival])) as TimeDiff
FROM yourtable

 

[buckwheat]

Thank you so much, this worked perfect. I am an operation manager and I am self tought access so I struggle with it. This worked perfrect.
Christina
Jax Fl

 

[buckwheat]

Another problem: I know have the the actual time displayed seperate as 7:10:00 am but the table I am calculating it against is in this format for example 6:50 is in the field as 6.83 I need to subtract one from the other to get the difference. Any ideas?

 

[buckwheat]

Figured it out, was easy enough. Thank you again so much for the help.
Christina