ccofmars
New Member
- Joined
- May 20, 2010
- Messages
- 44
Hi to you all,
I thank you in advance for taking the time to help me with this.
I am trying to do average of timevalue but I would like to exclude the cells where the time is 0:00 (h:mm)
the formula I am using is:
{=average(timevalue(right(I6:I3344,7)))}
It does work but unfortunally it also includes all the cells with 0:00 which gives me an average of 0:00 when I need to exclude these cells
how can I exclude 0:00 from the average? thank you thank you thank you ray:
I thank you in advance for taking the time to help me with this.
I am trying to do average of timevalue but I would like to exclude the cells where the time is 0:00 (h:mm)
the formula I am using is:
{=average(timevalue(right(I6:I3344,7)))}
It does work but unfortunally it also includes all the cells with 0:00 which gives me an average of 0:00 when I need to exclude these cells
how can I exclude 0:00 from the average? thank you thank you thank you ray: