Calculating Total Time

[camelk]

I have 2 flds: StartTime and EndTime (both formatted as short). I calculated the total number of hours worked by finding the difference between the StartTime and EndTime (no problem works fine). Now I need to add-up all the hours and minutes for a particular individual I wrote a query that selects all the records for a particular individual (works fine)and used "sum" to add all the hours and minutes for that indvividual. Problems is that it adds only the hours and not the minutes. How do I write a calculation so that the minutes as well as the hours are added.
Thanks

 

[RobertT687]

Try summing up the total time using minutes only. I'm assuming you're using a DateDiff function to get the difference between the start and end times. Divide the result by 60 to get hours.

 

[camelk]

Help I am so lost. This was how I arrived at the difference between EndTime and StartTime
TotTime: Format([EndTime]-[StartTime],"h:nn&quot
The results was in short format. How would I write this using DateDiff...and ....then total find the total of all hour worked. Please can someone help me?