Hi there,
I am working in the operations department for an airline. I am collecting information about the taxi time after landing. I would like to calculate the average of the taxi time (time inbeetween landing and arrival at the gate). The pivot chart is interesting for me to separate our 3 flights (AF006, AF032 and AF010). However I am not able to calculate the average, the DIV/0 error appears. All my formats are "h:mm". I have already tried to put "Use 1904 data system", and to display the hours using the "TEXT" function. I have even tried to make a pivot chart only for rows 1 to 7 and the DIV/0 still appears.
Do you have any idea on what's wrong ?
Thank you for your help !!EXCEL2.JPGEXCEL1.JPG
Bookmarks