Is there any report that shows sales by hour? We want to take a look at sales vs payroll and this would help.
There’s not, but you can run a Sales By Ship/Pickup Date report and include the Completed Time column. Then:
-
Make a new column to covert the completed time to hour using =TEXT(CELL,“HHHH”)
-
Then create a PivotTable and sum the Subtotal column by hour.
A few extra steps, but it will get you the information you need.