Totaling columns of time(not rows)

[spearson]

I have a table which in one column has a time formula such as 4:40 this is 4 hours and 40 minutes. I am calculating how much time was spent on a task. I cannot seem to figure out how to total a column. I want to do a query which is set up to filter certain date time lines. Within that date I want to know how much time each employee spend on a certain task. How do I do this? I was looking a total column but I can't figure out how to set up my query. Please speak english. Access is not my forte'

 

[Nouba]

try out this query and rename the fields by replacing tTaskID with your task's field name and tTimeSpent with your Date/Time field name.

SELECT
  T.tTaskID
, Format(Int(Sum(CDbl([tTimeSpent]))) * 24 + Hour(Sum(CDbl([tTimeSpent]))),"00\:") & 
    Format(Minute(Sum(CDbl([tTimeSpent]))),"00") AS MyTimeSum
FROM tblTaskTime AS T
GROUP BY T.tTaskID;

HTH nouba