Display Summary Week Total Rows From Sql Database

(I moved this thread from datagrid area) 
I have a sql database that has individual records consisting of name, date, hours worked among other fields.
Date and name is part of a unique identifier, so there can NOT be two records for the same person for the same date.
 My users need a grid view that displays days worked in ONE LINE per user. I have gotten close, but can't quite get the last part. Ive tried group by, distinct, and with rollup and no luck.
TABLE:dan       12/13/2012 12:00:00 AM9.123dan       12/14/2012 12:00:00 AM3.123123cara      12/12/2012 12:00:00 AM4.222cara      12/16/2012 12:00:00 AM3.3333cara      12/17/2012 12:00:00 AM2
 
 
 CODE:
Select distinct(name),
 (select (y.hours) from dbo.testtime y where y.name=YT.name AND y.hours = YT.hours and datename(dw, date)='Sunday')as Sunday,
 (select (y.hours) from dbo.testtime y where y.name=YT.name AND y.hours = YT.hours and datename(dw, date)='Monday')as Monday,
 (select (y.hours) from dbo.testtime y where y.name=YT.name AND y.hours = YT.hours and datename(dw, date)='Tuesday')as Tuesday,
 (select
(y.hours) from dbo.testtime y where y.name=YT.name AND y.hours =
YT.hours and datename(dw, date)='Wednesday')as Wednesday,
 (select
(y.hours) from dbo.testtime y where y.name=YT.name AND y.hours =
YT.hours and datename(dw, date)='Thursday')as Thursday,
 (select (y.hours) from dbo.testtime y where y.name=YT.name AND y.hours = YT.hours and datename(dw, date)='Friday')as Friday,
 (select
(y.hours) from dbo.testtime y where y.name=YT.name AND y.hours =
YT.hours and datename(dw, date)='Saturday')as Saturday,
(select sum(hours)from dbo.testtime y where y.name=YT.name AND y.hours = YT.hours) as Total
from dbo.testtime YT
group by date, name, hours
 
RESULTS:
 
cara          NULL    NULL    NULL    4.222    NULL    NULL    NULL    4.222
cara          NULL    2    NULL    NULL    NULL    NULL    NULL    2
cara          3.3333    NULL    NULL    NULL    NULL    NULL    NULL    3.3333
dan           NULL    NULL    NULL    NULL    NULL    3.123123    NULL    3.123123
dan           NULL    NULL    NULL    NULL    9.123    NULL    NULL    9.123
 
Like I said, I am SO close, I just need it to look like;
NAME    SUN    MIN    TU    WED    TH    FR    SA    TOTAL 
 cara          3.333    2                            4.222            9.555

dan                        9.125    3.125                              12.5
 
 
TIA
dan