Count the number of visits by visit types.

Hello guys,

I have dataset of doctor visits. These are my variables:

1. Day of Study (1,2 ,3; three days)
2. ROOM NUMBER (1,2,3,4; 4 different rooms)
3. VISIT TYPE (1 to 8; Eight different visits types)
4. TIME IN (number)
5. Time OUT (number)

AS you can see in tab 2, I need to"

1. count the number of visits each day by Visit type.
2. Average visit time by visit type. That is, the average time of TIME in - Time out, by visit type.
3. The maximum and minimum time of visit by visit type.

I would greatly appreciate if somebody help me with this. So I can learn by looking at the formulas.

Best,
MArvin