i have a column of numbers aht (average handle time) in seconds, and it is listed per
days of the week... for each of my agents, is there a formula to tkae the average and leave out the zero, if someone is absent..
412
300
356
435
0
=#div/0!.. i want to be able to use one formula and get the average no matter if a zero is present or not.. is it possible..??
days of the week... for each of my agents, is there a formula to tkae the average and leave out the zero, if someone is absent..
412
300
356
435
0
=#div/0!.. i want to be able to use one formula and get the average no matter if a zero is present or not.. is it possible..??