calculate time in the building

I have a report pulled from an access database. (not sure if I should go back
to access to do this easily)

I have data that includes the name of the vistor A2
the date of the visit B2
the type of service (check in or check out) c3
and the time of the service d4
So I now need to find the total time the person was in the building... I
have played with some different pivot tables, but I am stuck still doing a
lot of manual manipulation.
any ideas?

Do you want to know on a daily basis how long the person was in the building
or total?

"jenn" wrote:

> I have a report pulled from an access database. (not sure if I should go back
> to access to do this easily)
>
> I have data that includes the name of the vistor A2
> the date of the visit B2
> the type of service (check in or check out) c3
> and the time of the service d4
> So I now need to find the total time the person was in the building... I
> have played with some different pivot tables, but I am stuck still doing a
> lot of manual manipulation.
> any ideas?