Simple Macro that Totals Rows by Business Day

Back to consulting the excel geniuses,

I need help with a macro to give totals of the attached data by day of the month. So, once the macro is run the total rows for each business day will be displayed in a column on the right.

A business day for me is from 3am-0130am the next day.

It would be displayed like this when completed:

August 1, 2016: 205
August 2, 2016: 105
August 3, 2016: 308
and so on...

I have nothing currently built for this calculation... help, please?

That's insane!!!!

THANK YOU THANK YOU THANK YOU!!!

Hello again...

Would it be possible to provide a snippet that will make this code loop through all sheets in the workbook?

I couldn't get it to work... it's only running for one sheet... I attached a very simplified and small version of what I'm using as a data source...

Any ideas?

Pure excellence! It's crazy how good you are at this.

What if I wanted to add the totals by month to this macro? In column "M" it is broke down by day... is it possible to also put a monthly breakdown in column "N" for each sheet?