Spreadsheet: 119194d1314262893-i-need-to-track-sales-by-hour-need-help-creating-workbook-newln
Sheet: January

2011-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stats
Monday |  |  |  |  |  |  | Tuesday |  |  |  |  |  |  | Wednesday |  |  |  |  |  |  | Thursday |  |  |  |  |  |  | Friday |  |  |  |  |  |  | Saturday |  |  |  |  |  |  | Sunday
27 | IN | OUT | Total | LY IN | LY OUT | LY Total | 28 | IN | OUT | Total | LY IN | LY OUT | LY Total | 29 | IN | OUT | Total | LY IN | LY OUT | LY Total | 30 | IN | OUT | Total | LY IN | LY OUT | LY Total | 31 | IN | OUT | Total | LY IN | LY OUT | LY Total | 1 | IN | OUT | Total | LY IN | LY OUT | LY Total | 2 | IN | OUT | Total | LY IN | LY OUT | LY Total |  |  | Weekly | Monthly | Quarter
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Sales | 10000 | 10000
12am | 222 | 222 | 444 | 555 | 555 | 1110 | 12am | 222 | 222 | 444 | 555 | 555 | 1110 | 12am | 222 | 222 | 444 | 555 | 555 | 1110 | 12am | 222 | 222 | 444 | 555 | 555 | 1110 | 12am | 222 | 222 | 444 | 555 | 555 | 1110 | 12am | 222 | 222 | 444 | 555 | 555 | 1110 | 12am | 222 | 222 | 444 | 555 | 555 | 1110 |  | Total Late Night Sales | 3108 | 3108
1am |  |  | 0 |  |  | 0 | 1am |  |  | 0 |  |  | 0 | 1am |  |  | 0 |  |  | 0 | 1am |  |  | 0 |  |  | 0 | 1am |  |  | 0 |  |  | 0 | 1am |  |  | 0 |  |  | 0 | 1am |  |  | 0 |  |  | 0 |  | % Late Night of Sales | 0.3108 | 0.3108
2am |  |  | 0 |  |  | 0 | 2am |  |  | 0 |  |  | 0 | 2am |  |  | 0 |  |  | 0 | 2am |  |  | 0 |  |  | 0 | 2am |  |  | 0 |  |  | 0 | 2am |  |  | 0 |  |  | 0 | 2am |  |  | 0 |  |  | 0
3am |  |  | 0 |  |  | 0 | 3am |  |  | 0 |  |  | 0 | 3am |  |  | 0 |  |  | 0 | 3am |  |  | 0 |  |  | 0 | 3am |  |  | 0 |  |  | 0 | 3am |  |  | 0 |  |  | 0 | 3am |  |  | 0 |  |  | 0 |  | Last Year Sales | 10000 | 10000
4am |  |  | 0 |  |  | 0 | 4am |  |  | 0 |  |  | 0 | 4am |  |  | 0 |  |  | 0 | 4am |  |  | 0 |  |  | 0 | 4am |  |  | 0 |  |  | 0 | 4am |  |  | 0 |  |  | 0 | 4am |  |  | 0 |  |  | 0 |  | Last Year Total Late Night Sales | 7770 | 7770
5am |  |  | 0 |  |  | 0 | 5am |  |  | 0 |  |  | 0 | 5am |  |  | 0 |  |  | 0 | 5am |  |  | 0 |  |  | 0 | 5am |  |  | 0 |  |  | 0 | 5am |  |  | 0 |  |  | 0 | 5am |  |  | 0 |  |  | 0 |  | % Late Night of Sales | 0.777 | 0.777
Total | 222 | 222 | 444 | 555 | 555 | 1110 | Total | 222 | 222 | 444 | 555 | 555 | 1110 | Total | 222 | 222 | 444 | 555 | 555 | 1110 | Total | 222 | 222 | 444 | 555 | 555 | 1110 | Total | 222 | 222 | 444 | 555 | 555 | 1110 | Total | 222 | 222 | 444 | 555 | 555 | 1110 | Total | 222 | 222 | 444 | 555 | 555 | 1110
% of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  | % of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  | % of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  | % of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  | % of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  | % of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  | % of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  |  | % Late Night Sales Change This Year Over Last | -0.6 | -0.6
3 | IN | OUT | Total | LY IN | LY OUT | LY Total | 4 | IN | OUT | Total | LY IN | LY OUT | LY Total | 5 | IN | OUT | Total | LY IN | LY OUT | LY Total | 6 | IN | OUT | Total | LY IN | LY OUT | LY Total | 7 | IN | OUT | Total | LY IN | LY OUT | LY Total | 8 | IN | OUT | Total | LY IN | LY OUT | LY Total | 9 | IN | OUT | Total | LY IN | LY OUT | LY Total |  |  | Weekly | Monthly | Quarter
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Sales | 10000 | 20000
12am | 222 | 222 | 444 | 555 | 555 | 1110 | 12am | 222 | 222 | 444 | 555 | 555 | 1110 | 12am | 222 | 222 | 444 | 555 | 555 | 1110 | 12am | 222 | 222 | 444 | 555 | 555 | 1110 | 12am | 222 | 222 | 444 | 555 | 555 | 1110 | 12am | 222 | 222 | 444 | 555 | 555 | 1110 | 12am | 222 | 222 | 444 | 555 | 555 | 1110 |  | Total Late Night Sales | 3108 | 6216
1am |  |  | 0 |  |  | 0 | 1am |  |  | 0 |  |  | 0 | 1am |  |  | 0 |  |  | 0 | 1am |  |  | 0 |  |  | 0 | 1am |  |  | 0 |  |  | 0 | 1am |  |  | 0 |  |  | 0 | 1am |  |  | 0 |  |  | 0 |  | % Late Night of Sales | 0.3108 | 0.3108
2am |  |  | 0 |  |  | 0 | 2am |  |  | 0 |  |  | 0 | 2am |  |  | 0 |  |  | 0 | 2am |  |  | 0 |  |  | 0 | 2am |  |  | 0 |  |  | 0 | 2am |  |  | 0 |  |  | 0 | 2am |  |  | 0 |  |  | 0
3am |  |  | 0 |  |  | 0 | 3am |  |  | 0 |  |  | 0 | 3am |  |  | 0 |  |  | 0 | 3am |  |  | 0 |  |  | 0 | 3am |  |  | 0 |  |  | 0 | 3am |  |  | 0 |  |  | 0 | 3am |  |  | 0 |  |  | 0 |  | Last Year Sales | 10000 | 20000
4am |  |  | 0 |  |  | 0 | 4am |  |  | 0 |  |  | 0 | 4am |  |  | 0 |  |  | 0 | 4am |  |  | 0 |  |  | 0 | 4am |  |  | 0 |  |  | 0 | 4am |  |  | 0 |  |  | 0 | 4am |  |  | 0 |  |  | 0 |  | Last Year Total Late Night Sales | 7770 | 15540
5am |  |  | 0 |  |  | 0 | 5am |  |  | 0 |  |  | 0 | 5am |  |  | 0 |  |  | 0 | 5am |  |  | 0 |  |  | 0 | 5am |  |  | 0 |  |  | 0 | 5am |  |  | 0 |  |  | 0 | 5am |  |  | 0 |  |  | 0 |  | % Late Night of Sales | 0.777 | 0.777
Total | 222 | 222 | 444 | 555 | 555 | 1110 | Total | 222 | 222 | 444 | 555 | 555 | 1110 | Total | 222 | 222 | 444 | 555 | 555 | 1110 | Total | 222 | 222 | 444 | 555 | 555 | 1110 | Total | 222 | 222 | 444 | 555 | 555 | 1110 | Total | 222 | 222 | 444 | 555 | 555 | 1110 | Total | 222 | 222 | 444 | 555 | 555 | 1110
% of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  | % of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  | % of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  | % of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  | % of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  | % of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  | % of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  |  | % Late Night Sales Change This Year Over Last | -0.6 | -0.6
10 | IN | OUT | Total | LY IN | LY OUT | LY Total | 11 | IN | OUT | Total | LY IN | LY OUT | LY Total | 12 | IN | OUT | Total | LY IN | LY OUT | LY Total | 14 | IN | OUT | Total | LY IN | LY OUT | LY Total | 14 | IN | OUT | Total | LY IN | LY OUT | LY Total | 15 | IN | OUT | Total | LY IN | LY OUT | LY Total | 16 | IN | OUT | Total | LY IN | LY OUT | LY Total |  |  | Weekly | Monthly | Quarter
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Sales | 10000 | 30000
12am | 222 | 222 | 444 | 555 | 555 | 1110 | 12am | 222 | 222 | 444 | 555 | 555 | 1110 | 12am | 222 | 222 | 444 | 555 | 555 | 1110 | 12am | 222 | 222 | 444 | 555 | 555 | 1110 | 12am | 222 | 222 | 444 | 555 | 555 | 1110 | 12am | 222 | 222 | 444 | 555 | 555 | 1110 | 12am | 222 | 222 | 444 | 555 | 555 | 1110 |  | Total Late Night Sales | 3108 | 9324
1am |  |  | 0 |  |  | 0 | 1am |  |  | 0 |  |  | 0 | 1am |  |  | 0 |  |  | 0 | 1am |  |  | 0 |  |  | 0 | 1am |  |  | 0 |  |  | 0 | 1am |  |  | 0 |  |  | 0 | 1am |  |  | 0 |  |  | 0 |  | % Late Night of Sales | 0.3108 | 0.3108
2am |  |  | 0 |  |  | 0 | 2am |  |  | 0 |  |  | 0 | 2am |  |  | 0 |  |  | 0 | 2am |  |  | 0 |  |  | 0 | 2am |  |  | 0 |  |  | 0 | 2am |  |  | 0 |  |  | 0 | 2am |  |  | 0 |  |  | 0
3am |  |  | 0 |  |  | 0 | 3am |  |  | 0 |  |  | 0 | 3am |  |  | 0 |  |  | 0 | 3am |  |  | 0 |  |  | 0 | 3am |  |  | 0 |  |  | 0 | 3am |  |  | 0 |  |  | 0 | 3am |  |  | 0 |  |  | 0 |  | Last Year Sales | 10000 | 30000
4am |  |  | 0 |  |  | 0 | 4am |  |  | 0 |  |  | 0 | 4am |  |  | 0 |  |  | 0 | 4am |  |  | 0 |  |  | 0 | 4am |  |  | 0 |  |  | 0 | 4am |  |  | 0 |  |  | 0 | 4am |  |  | 0 |  |  | 0 |  | Last Year Total Late Night Sales | 7770 | 23310
5am |  |  | 0 |  |  | 0 | 5am |  |  | 0 |  |  | 0 | 5am |  |  | 0 |  |  | 0 | 5am |  |  | 0 |  |  | 0 | 5am |  |  | 0 |  |  | 0 | 5am |  |  | 0 |  |  | 0 | 5am |  |  | 0 |  |  | 0 |  | % Late Night of Sales | 0.777 | 0.777
Total | 222 | 222 | 444 | 555 | 555 | 1110 | Total | 222 | 222 | 444 | 555 | 555 | 1110 | Total | 222 | 222 | 444 | 555 | 555 | 1110 | Total | 222 | 222 | 444 | 555 | 555 | 1110 | Total | 222 | 222 | 444 | 555 | 555 | 1110 | Total | 222 | 222 | 444 | 555 | 555 | 1110 | Total | 222 | 222 | 444 | 555 | 555 | 1110
% of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  | % of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  | % of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  | % of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  | % of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  | % of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  | % of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  |  | % Late Night Sales Change This Year Over Last | -0.6 | -0.6
17 | IN | OUT | Total | LY IN | LY OUT | LY Total | 18 | IN | OUT | Total | LY IN | LY OUT | LY Total | 19 | IN | OUT | Total | LY IN | LY OUT | LY Total | 20 | F/C | D/T | Total | LY F/C | LY D/T | LY Total | 21 | IN | OUT | Total | LY IN | LY OUT | LY Total | 22 | IN | OUT | Total | LY IN | LY OUT | LY Total | 23 | IN | OUT | Total | LY IN | LY OUT | LY Total |  |  | Weekly | Monthly | Quarter
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Sales | 10000 | 40000
12am | 222 | 222 | 444 | 555 | 555 | 1110 | 12am | 222 | 222 | 444 | 555 | 555 | 1110 | 12am | 222 | 222 | 444 | 555 | 555 | 1110 | 12am | 222 | 222 | 444 | 555 | 555 | 1110 | 12am | 222 | 222 | 444 | 555 | 555 | 1110 | 12am | 222 | 222 | 444 | 555 | 555 | 1110 | 12am | 222 | 222 | 444 | 555 | 555 | 1110 |  | Total Late Night Sales | 3108 | 12432
1am |  |  | 0 |  |  | 0 | 1am |  |  | 0 |  |  | 0 | 1am |  |  | 0 |  |  | 0 | 1am |  |  | 0 |  |  | 0 | 1am |  |  | 0 |  |  | 0 | 1am |  |  | 0 |  |  | 0 | 1am |  |  | 0 |  |  | 0 |  | % Late Night of Sales | 0.3108 | 0.3108
2am |  |  | 0 |  |  | 0 | 2am |  |  | 0 |  |  | 0 | 2am |  |  | 0 |  |  | 0 | 2am |  |  | 0 |  |  | 0 | 2am |  |  | 0 |  |  | 0 | 2am |  |  | 0 |  |  | 0 | 2am |  |  | 0 |  |  | 0
3am |  |  | 0 |  |  | 0 | 3am |  |  | 0 |  |  | 0 | 3am |  |  | 0 |  |  | 0 | 3am |  |  | 0 |  |  | 0 | 3am |  |  | 0 |  |  | 0 | 3am |  |  | 0 |  |  | 0 | 3am |  |  | 0 |  |  | 0 |  | Last Year Sales | 10000 | 40000
4am |  |  | 0 |  |  | 0 | 4am |  |  | 0 |  |  | 0 | 4am |  |  | 0 |  |  | 0 | 4am |  |  | 0 |  |  | 0 | 4am |  |  | 0 |  |  | 0 | 4am |  |  | 0 |  |  | 0 | 4am |  |  | 0 |  |  | 0 |  | Last Year Total Late Night Sales | 7770 | 31080
5am |  |  | 0 |  |  | 0 | 5am |  |  | 0 |  |  | 0 | 5am |  |  | 0 |  |  | 0 | 5am |  |  | 0 |  |  | 0 | 5am |  |  | 0 |  |  | 0 | 5am |  |  | 0 |  |  | 0 | 5am |  |  | 0 |  |  | 0 |  | % Late Night of Sales | 0.777 | 0.777
Total | 222 | 222 | 444 | 555 | 555 | 1110 | Total | 222 | 222 | 444 | 555 | 555 | 1110 | Total | 222 | 222 | 444 | 555 | 555 | 1110 | Total | 222 | 222 | 444 | 555 | 555 | 1110 | Total | 222 | 222 | 444 | 555 | 555 | 1110 | Total | 222 | 222 | 444 | 555 | 555 | 1110 | Total | 222 | 222 | 444 | 555 | 555 | 1110
% of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  | % of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  | % of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  | % of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  | % of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  | % of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  | % of Sales | 0.5 | 0.5 |  | 0.5 | 0.5 |  |  | % Late Night Sales Change This Year Over Last | -0.6 | -0.6