Hi, How to calculate the average of the following data sets in the below column. I tried using text to column tool to separate data into different column but I am not sure whether it's correct way to calculate average. Please advice. Length of Appointments5159,4646,55,67,49,6071,6240,61,6570,31,6157,58,4162,4367,3243,464535,454953,27,5166,69,4863,50547336,4842,70,475165,75,33,53,5832,56,6341,34,6249,74,7347,3668,37,5832 Thanks, Kaveri Jaiswal

Average

Hi,

How to calculate the average of the following data sets in the below column. I tried using text to column tool to separate data into different column but I am not sure whether it's correct way to calculate average. Please advice.

Length of Appointments
51
59,46
46,55,67,49,60
71,62
40,61,65
70,31,61
57,58,41
62,43
67,32
43,46
45
35,45
49
53,27,51
66,69,48
63,50
54
73
36,48
42,70,47
51
65,75,33,53,58
32,56,63
41,34,62
49,74,73
47,36
68,37,58
32