Community Forum

Sales by Hour?

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:

  1. Make a new column to covert the completed time to hour using =TEXT(CELL,“HHHH”)

  2. Then create a PivotTable and sum the Subtotal column by hour.

A few extra steps, but it will get you the information you need.