im trying to average over a number of work sheets to determine the avergage talk time of employees over a day, ive tried:
Were Persons name is the name of the worksheet and h16 is the cell i wish to average, i keep getting a value error or simply that it wont work, i understand that i can use a vba to do this although i am not familliar with this is there another way to average the time over a number of worksheets? i know i could just remove the zeros from the cells but the info in them is taken from another sheet so it is not possible to do that.Please Login or Register to view this content.
Thanks Scott
Bookmarks