Hi smart people!
So I have a list of all customer orders placed over the last year.
My objective is ultimately to see how many orders are placed during our out-of-hours periods (so, any orders placed before 8:30am, after 5:30pm, and at weekends).
My date/time column looks like this...
Capture column.PNG
So I need a way to somehow filter the out of hours periods in this column. Ideally, I would be able to see some sort of table/visual of orders placed during open hours vs closed hours. Or failing that, just a way to literally filter them out so I can make my own calculations.
Can anyone please help me? Thanks in advance!
Bookmarks