M,
If these formulas were in D2:D4, you could use =AVERAGE(TIMEVALUE(D2:D4)). This is an array
formula, and must be commited to the cell with Ctrl-Shift-Enter, not just Enter.
It might be simpler to just keep your times in true date-time format rather than converting
to text. In your original formula, use =C2-B2 and format for time as desired (Format -
Cells - Number tab). Time calculations are straightfoward done that way. Well, mostly.
You have to change the formatting in many cases.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"m greenly" <m
wrote in message
...
i have times listed as "h:mm" and i would like to show the average. note that
the times are calculated, not entered manually.
formula in time row: =TEXT(C2-B2, "h:mm")
what formula would i put in the cell where i want the average of all times?
thanks for your help.