AnsweredAssumed Answered

how to calculate an average for time duration in todays date?

Question asked by gasolineman on Apr 6, 2011
Latest reply on Apr 6, 2011 by philmodjunk

Title

how to calculate an average for time duration in todays date?

Post

have asked this questions once or twice and never got anywhere.  

i have a field in a record that notes the time when the rcord is created.  i have another field where i can enter the time i stopped working on a record.  i have a calculated field that subtracts the two and successfully gives me an amount of time i was on that record.  

what i want is... a field that give me an average time for all records time created in todays date. i am open to using more than one table, but i am unclear as to what to put in a second table and how to calculate that average.  

i would ideally like to do this by using only a single calculation in a field, but most people think it will require a second table.  if you think this is the solution can you explain why and what fields i would need in that second table?  what the calulations might look like etc.

thanks in advance.

Outcomes