how to aggregate values from different rows but same user

From: colin_lyse <colin_lyse_at_98fgfgs.com>
Date: 21 Sep 2005 17:52:28 -0500
Message-ID: <4331e39f$0$6853$bb4e3ad8@newscene.com>

we have a table of usage

date_time               in_out          user
9/1/05 13:22            in              joe
9/1/05 13:21            in              sue
9/1/05 14:33            out              joe
9/1/05 14:42            in              sam
9/1/05 13:22            out              sue
9/1/05 17:44            out              sam

i want to get the following

user    in                 out     date
joe     13:22           14:33   9/1/05

etc

also

for a partiuclar day and hour how many users were IN at the time for example

date hour # of users

9/1/05  13      3 
9/1/05  14      2
9/1/05  15      1
9/1/05  16      1
9/1/05  17      1

any ideas Received on Wed Sep 21 2005 - 17:52:28 CDT