how to calculate an average for time duration in todays date?
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.