How to Average elapsed time values?
Sounds like they are text. Try this
=AVERAGE(IF(D1:D100<"",--(D1:D100)))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"MTB_AR" wrote in message
...
I have a column with elapsed time values like 01:45, 02:25, 01:58, etc. I
can't seem to get the average to work out right using other posts, so can
anyone help me out! I have 667 values in colum M. All the values have a
0
as first number.
If I remove the 0 from the time, I have no problem, but that would take
forever, at least with my skill level!
|