How to calculate average of multiple times for multiple days on a single spreadsheet?

I am a moderately experienced user of Office and Excel but have run against a brick wall with what I am trying to do.  In a nutshell, I have a spreadsheet with data from a weather station that has ro...