"total Time Sum"

[unclefink]

I am trying to create a report to show total time and miles to account for miles ridden on a bike.

I currently have a report showing the basic part of what im looking for IE: total Miles and time ridden in each record. What i am trying to do is make a calculation to show me how many total hours:Minutes a person rode over a period of time.

StartDateTime EndDateTime TotalTime
11/19/2012 02:00 11/19/2012 07:00 5:00
11/19/2012 06:00 11/19/2012 09:30 3:30
___________________________________________
8:30

The sum of total time is what i am trying to come to. In the example above 8:30?

I am grouping my report by individual riders and just want their overall total time.

 

[ypma]

Based on the basic data you provided I have knock-up a sample database of my interpretation of your question and hope it is of some use. Be warned i am just a user like your self so there will be other ways to acheive the result you are trying to achieve.