Help in calculating total time worked

[Rajeshsms]

Dear All,



I have a table in access that has 1 ) persons ID and ) log date/time 3) direction in or out
I need to calculate the amount of time spent by the person in the office. e.g User with ID 1 will come in at 8 in the morning and go out after an hour
then come in again and go out. Till he leaves out for the day. I need to find the first time he came in and last time he went out and find the difference
for the hours he worked

The data is in Devicelogs table


Many thanks

[ranman256]

query the table and add extra calculated column to calc the hours in the IN vs OUT time / person / day
datediff("h",date1, date2)

sum the hours.

[Rajeshsms]

Many thanks for the answer but I am still not sure. I just need to calculate the first in and the last out and difference between those two times

Regards

[recyan]

Do not if below will give you some guidelines. All the same check out :

https://www.accessforums.net/queries...yee-25759.html

Thanks