Average
Thank you!
"petedacook" wrote:
Set the format in the results field to TIME, then select the TYPE 30:55:.2
from the format cells dialog box.
"Chi" wrote:
Hi,
I would like to average hours (h:mm format) on column J from cell 2 to cell
150
My formula for Average is =Average IF (J2:J150), "<0", but the result is
wrong.
Since there are many cells don't have any value yet, I would like to average
the cells have values only.
Thanks
Chi
|