Calculating Sum of Time

[CRAMan]

In my database I track how much time each person puts into a project usign a time feild. this si displayed as HH:MM on a 24 hour clock.

What i want to do is in the report SUM all of the time from each person into one total per project. How would i do this?

 

[mdthornton]

Are your times stored as strings?
Is there a start time and end time or is each entry just an elapsed time? Best Regards,
Mike

 

[WildHare]

Not to pee on your parade, CRAMan, but you're probably going to be better off storing your times as numeric entries rather than date/time fields. Date/Time fields are used to store an INSTANT in TIME, not an ELAPSED amount of time.

You have to do all kinds of fancy date arithmetic to get accurate elapsed times when you do it your way. Storing the elapsed times as simple numbers makes it much easier.

Just remember to do whatever appropriate edit checking is necessary, e.g. no more than x hours in a day or whatever...

Ex-JimAtTheFAA
78.5% of all statistics are made up on the spot.
Another free Access forum:

http://www.forumco.com/jmhare

More Neat Access stuff at

http://www.jmhare.com/wildhare2.htm