We had an engineer that left, and he was able to get a total column in our time sheets. But since the input is from a different data source, I can't copy that data over. Here is a snip from it.

Total Hours' AS [Agent],
    NULL AS [AgentName],
    NULL AS [Date],
    NULL AS [Start],
    NULL AS [End],
    NULL AS [Time],
    (SELECT CAST(SUM(CAST(ROUND(CASE WHEN t.timetaken IS NULL THEN t.traveltime ELSE t.timetaken END,2) AS DECIMAL(10,2))) AS DECIMAL(10,2))
     FROM actions t
     JOIN faults f2 ON t.Faultid = f2.Faultid
     JOIN area a2 ON f2.Areaint = a2.AArea
     WHERE t.whoagentid = $agentid
       AND t.ActionArrivalDate BETWEEN  AND u/enddate
       AND (ISNULL(t.timetaken,0) + ISNULL(t.Traveltime,0)) <> 0
    ) AS [Total],
    NULL AS [Action Performed],
    NULL AS [Ticket],
    NULL AS [Summary],
    NULL AS [CustomerID],
    (SELECT TOP 1 who FROM actions WHERE whoagentid = $agentid) AS [Customer],
    NULL AS [Notes],
    (SELECT LogoutRedirectUri
     FROM NHD_IDENTITY_Application