Hi everyone, first post for me and I could do with some advice in relation to a problem that has been causing me a headache all day!

I have a start time and end time for each event and would like to work out Peak Time AND Peak Day over a week long period from Monday 00:00hrs to Sunday 23:59hrs.

I've created a simple spreadsheet (attached) showing how the original data looks along with some simple formatting I've added to work out duration etc.

Towards the right hand side of the sheet I've created how I imagine the data will look at the end of the process, with a score of "1" for every hour in question that I'm concerned with. I'd then sum the data in the last row to work out the peak time / day from Monday to Sunday.

My full data set is about 40,000 rows hence the reason I'd like to automate the process!

I've seen examples that work out just the Day or the Month distribution etc but not one that works on Day AND Hour in one go.

Any ideas / advice would be greatly appreciated

MPeak_Time_Day.xlsx