1. SELECT tpr.PROJECTID "Module ID",'Project' "Module" , MAX(pr.TITLE) "Title", CAST(SUM(ct.TIMESPENT) AS FLOAT)/1000/3600
    "Time Spent",dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (MAX(ct.CREATEDTIME)/1000),'1970-01-01 00:00:00') "Time Spent Created Time",rctd.FIRST_NAME "Time Spent Technician" FROM ChargesTable ct
   LEFT JOIN TaskToCharge tkc ON ct.CHARGEID=tkc.CHARGEID
   LEFT JOIN  TaskDetails tk ON tkc.TASKID=tk.TASKID
   LEFT JOIN TaskTOProjects tpr ON tk.taskid=tpr.taskid
   LEFT JOIN ProjectDetails pr ON tpr.PROJECTID=pr.PROJECTID
   LEFT JOIN SDUser rcti ON ct.TECHNICIANID=rcti.USERID LEFT JOIN AaaUser rctd ON rcti.USERID=rctd.USER_ID WHERE tk.MODULE IN ('project', 'milestone') AND ct.CREATEDTIME >= <from_lastweek> AND ct.CREATEDTIME <= <to_lastweek> GROUP BY tpr.PROJECTID,rctd.FIRST_NAME, ct.CREATEDTIME]

The code above was from other threads, trimmed down to this.  It returns Total Project Hours/Day/Technician.  What I would like to do is sum the technician hours now to a single line...

Any thoughts?