Calculate time difference

[desireemm1]

I have to give the difference between when the time the call was taken and when the call was returned in hours. that way they can see how long it takes to return a customers call

[desireemm1]

the problem is solved thank you so much guys I really appreciate it.

TotalHours: DateDiff("h",[Date & Time Left],[Date Returned])

[June7]

Why is [Date Returned] a text field?

[desireemm1]

is not anymore and I'm not sure. I do have another question, if I need to calculate each call per hour (based off the [Date & Time Left] field)
example:

6am 5calls
7am 6calls

how exactly would I do that? I have to do that in a report

SELECT [Message Tracking].Caller, [Message Tracking].[Customer Type], [Message Tracking].[Date Returned], [Message Tracking].ID, [Message Tracking].[Request ID], [Message Tracking].[Date & Time Left], Sum([Message Tracking].[Date & Time Left]) AS [SumOfDate & Time Left]
FROM [Message Tracking]
GROUP BY [Message Tracking].Caller, [Message Tracking].[Customer Type], [Message Tracking].[Date Returned], [Message Tracking].ID, [Message Tracking].[Request ID], [Message Tracking].[Date & Time Left]
HAVING ((([Message Tracking].[Date & Time Left]) Between [Beginning_Date & Time Left] And [End_Date & Time Left]));

[June7]

Need to extract the hour part of the date/time and use that as grouping/sorting criteria.

Hour([Date & Time Left])