Hi ,I basically have 2 rows of data, One containing Column Names and the other Column times , I am basically trying to caclulate the average time spent on a call per person from the column name. below is an example and I have also attached a Spreadsheet as we.I have tried using the average and average if fuction but it does return any values
AI BI
Who Solved Calculated MTTF
Jack 15:40:39
Mike 16:40:39
Paul 17:40:39
Bill 18:40:39
Jack 19:40:39
Jack 20:40:39
Bill 21:40:39
Mike 22:40:39
Paul 23:40:30
Thanks
Darrylc
Bookmarks