Hello everyone.

I have a project that I'm working on for my company, and basically we have gathered a bunch of data that involves a range of numbers that vary from hour to hour on each day of the month.

I'm looking to put these ranges into excel, and then gather an average range at the end, but I'm not sure if there's a convenient way of doing this, so that's why I'm here.


I'm trying to get something that essentially looks like this

10:00 [15 - 50] [14 - 16] [12 - 62] [AVG RANGE]
11:00 [12 - 60] [55 - 60] [55 - 90] [AVG RANGE]
12:00 [10 - 35] [13 - 52] [22 - 62] [AVG RANGE]

Thank you for your help in advance.