Sum of time fields (1 Viewer)

[RyLane]

Hi,

I have a form generated from infopath where users enter the amount of time it took them to complete a task. It is set up right now in time format, so a user would enter Task A-0:15 (to show 15 minutes). Users have multiple tasks with different times and I would like to be able to show a total for all those tasks combined.

Task A-0:15
Task B-0:45
Task C-1:30
Task D-0:30
Total = 3:00 <------This is what I would like to do

Thanks

 

[RyLane]

Found a solution in another thread and it works for me

http://www.access-programmers.co.uk/forums/showthread.php?t=193282

But is there a way to do this in the query with a separate field?