Daily, Weekly, Monthly Individual Tech time in task Repoert
Somewhat hard to judge without any idea of the schema, but here are a few observations:


Join condition on billableType table is questionable: why comparing an ID to a rank in INNER JOIN billableType ON billingsTimes.billableTypeID = billableType.rank?
Try to limit GROUP BY to the columns that will become sort of 'logical key' of your result set. E.g. it seems the query is limited to a single task at a time (billingTimes.taskID = ###). Use max(taskName) as taskName in your select list and exclude taskName from the group by clause.
There's no need for datepart(D, dateOfService) in GROUP BY: the query is already restricted to a single day.