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?