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?