#ERROR when subtracting 2 times

[Liz_I3]

Hello
I am working in MS Access 16 on the query grid I have 2 time fields LastOfTime Out and FirstOfTime In I want to create a Time Spent field by subtract the 2 times

Time Spent: [LastOfTime Out] - [FirstOfTime In] Would be like this 4:07:00 PM-8:05:00 AM I get #Error

Thanks
L

 

[Liz_I3]

Yes you are correct was trying to remove time from date. The first field date and time is not text.

 

[Joe4]

OK, it shouldn't really be necessary to remove the date piece then, so I don't think you need to use the TimeValue function (as long as you are subtracting the fields from your original table, and not from some calculated field that you created that may have converted it to Text).

 

[Liz_I3]

I was using a calculated field but let me try it with the date and time field. Will post back
Thanks you so much for your time. I helps just to talk it out

L

 

[Joe4]

You are welcome.

If you have still have issues, or determine for some reason you need to do it on the calculated fields, post those calculations and we can see if we can change it to return date/time instead of text.
Or, just include any carry the original fields through the queries. There isn't a reason why you cannot have both (the calculated and the original), and just drop the one you don't need from your query results.

 

[Liz_I3]

ok Thanks you