Calculating average trip times for a schedule

[PCloadletter]

Hello,

I have an excel sheet with a schedule for a shuttle service. In one column, I have the shuttle arrival times from 5 am until 11 pm one direction and in another column I have the arrival times for the opposite direction.

The arrival times will vary due to driver breaks and traffic conditions.

Is there a way to calculate the average trip times of each column?

Is there a way to calculate average trip times during, for example peak hours (5 am - 9 am)

Thank you in advance as always.

 

[Yongle]

please post some sample data
XL2BB is the site tool for that

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com