The Difference Between Two Date Fields to get total time

[desireemm]

Hello I have to create a query in access that will calculate two Date and time fields [Date & Time Left]/ [Date Returned], need to figure out between the two fields. Trying to identify when the rep returned the call and the number of business hours (6:00am - 4:30pm) it takes to return a message in Ms Access 2010. Can anyone help please

The only issue is the calculation has to be done by time and so I have to calculate what time they left the message(so the difference between [Date & Time Left] and [Date Returned) [Date & Time Left] and when the rep returned the message which is suppose to be [Date Returned] but the problem with this field is the data entry is in date format (10/9/2014, 00/00/0000) of Date and not Date and Time like the [Date & Time Left] field, so I don't know what to do now. Not sure what to do now not a database that create or have allot of control over. Can anyone please help

thank you

 

[plog]

You lost me. Can you provide some sample data to demonstrate what data you have and what data you want to produce based on that data? Be sure to include table and field names.

 

[desireemm]

Date Returned Date & Time Left
10/23/2014 10/23/2014 6:27:00 AM
10/23/2014 10/23/2014 7:28:00 AM
10/23/2014 10/23/2014 7:22:00 AM
10/23/2014 10/22/2014 10:42:00 AM
10/22/2014 10/22/2014 9:35:00 AM
10/22/2014 10/22/2014 9:20:00 AM


the data type in [Date & Time Left] is Date/Time and the Data type in Date Returned is Text


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

 

[plog]

First, delimit your data with commas. I can't see where one field ends and the other begins. Second, it sounds like you've only provided me with starting data. I also need what you expect as a result.

TableNameHere
Field1NameHere, Field2NameHere, Field3NameHere, ExpectedResultHere
David, 7, 9, 16
Larrry, 41, 20, 61
Sally, 17, -9, 8

 

[namliam]

You cant see the time between the two, since [Date returned] does not have a time component... as a matter of fact in your date returned the call was returned before it was recieved

Also there will be a significant swing without the time component in the Date Returned