Hi Peter!
Averaging times is not essentially different from averaging any
number. Note that Excel times are recorded as a decimal part of a day,
so averaging is simply averaging of these decimals.
However, I suspect that you are wanting to average durations; the time
between starting and completion.
You can work out durations for each project allowing for a span of
midnight using:
=B1-A1+(B1<A1)
To calculate the average you can sum these separate results or you can
use the array entered formula:
=AVERAGE(B1:B30-A1:A30+(B1:B30<A1:A30))
Entered by pressing and holding down Ctrl+Shift and then pressing
Enter
Appears in the formula bar as
{=AVERAGE(B1:B20-A1:A20+(B1:B20<A1:A20))}
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH.
See:
http://www.microsoft.com/security/protect/
