Hello,
I'm new to this board and from what I have read I think you guys wont have any problem with this question at all..
I work tracking information on employees. At my job they work with handhelds ( RF's ) to count parts in a warehouse.. Every transaction they do is recorded on our system and imported into excel where I have a pivot table breaking down that information into (qty, time stamps,total transactions and user name). What I would like to do is break it down even more so I can get hourly data. How many transactions they did in that hour and qty.
<table border="0" cellpadding="0" cellspacing="0" width="300"><col style="width: 69pt;" width="92"> <col style="width: 57pt;" width="76"> <col style="width: 99pt;" width="132"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 69pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; background: none repeat scroll 0% 0% rgb(219, 229, 241);" height="20" width="92">
</td> <td style="width: 57pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; background: none repeat scroll 0% 0% rgb(219, 229, 241);" width="76">Values</td> <td style="width: 99pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; background: none repeat scroll 0% 0% rgb(219, 229, 241);" width="132">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(219, 229, 241);" height="20">Row Labels</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(219, 229, 241);">Sum of PCS</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(219, 229, 241);">Sum of Transactions</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215);" height="20">Frank</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215);" align="right">47</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215);" align="right">2</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">3:02:00</td> <td align="right">2</td> <td align="right">1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">3:04:00</td> <td align="right">45</td> <td align="right">1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215);" height="20">Jeff</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215);" align="right">70</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215);" align="right">2</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">3:12:00</td> <td align="right">60</td> <td align="right">1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">3:17:00</td> <td align="right">10</td> <td align="right">1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215);" height="20">John</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215);" align="right">6147</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215);" align="right">3</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">3:01:00</td> <td align="right">104</td> <td align="right">1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">3:10:00</td> <td align="right">1000</td> <td align="right">1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">3:15:00</td> <td align="right">5043</td> <td align="right">1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: 0.5pt medium medium; border-style: solid none none; border-color: rgb(149, 179, 215) -moz-use-text-color -moz-use-text-color; background: none repeat scroll 0% 0% rgb(219, 229, 241);" height="20">Grand Total</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: 0.5pt medium medium; border-style: solid none none; border-color: rgb(149, 179, 215) -moz-use-text-color -moz-use-text-color; background: none repeat scroll 0% 0% rgb(219, 229, 241);" align="right">6264</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: 0.5pt medium medium; border-style: solid none none; border-color: rgb(149, 179, 215) -moz-use-text-color -moz-use-text-color; background: none repeat scroll 0% 0% rgb(219, 229, 241);" align="right">7</td> </tr> </tbody></table>
This is sorta the way it looks like at the moment.. So as you see I have to go by timestamps and break down how many they did in a hour and the number of pcs.
The pivot table grows all day long. I can add code to add between the hours each time I update but I would like to have this done automatically if possible..
I would like to see
John at 4:00:00 did a total of 6147 pcs and 3 transactions
We work 8 hour shifts so it would be nice if the pivot table could do that every hour.
Sorry if my detail is not that great.. But is this possible?
Thanks
I'm new to this board and from what I have read I think you guys wont have any problem with this question at all..
I work tracking information on employees. At my job they work with handhelds ( RF's ) to count parts in a warehouse.. Every transaction they do is recorded on our system and imported into excel where I have a pivot table breaking down that information into (qty, time stamps,total transactions and user name). What I would like to do is break it down even more so I can get hourly data. How many transactions they did in that hour and qty.
<table border="0" cellpadding="0" cellspacing="0" width="300"><col style="width: 69pt;" width="92"> <col style="width: 57pt;" width="76"> <col style="width: 99pt;" width="132"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 69pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; background: none repeat scroll 0% 0% rgb(219, 229, 241);" height="20" width="92">
</td> <td style="width: 57pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; background: none repeat scroll 0% 0% rgb(219, 229, 241);" width="76">Values</td> <td style="width: 99pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; background: none repeat scroll 0% 0% rgb(219, 229, 241);" width="132">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(219, 229, 241);" height="20">Row Labels</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(219, 229, 241);">Sum of PCS</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(219, 229, 241);">Sum of Transactions</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215);" height="20">Frank</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215);" align="right">47</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215);" align="right">2</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">3:02:00</td> <td align="right">2</td> <td align="right">1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">3:04:00</td> <td align="right">45</td> <td align="right">1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215);" height="20">Jeff</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215);" align="right">70</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215);" align="right">2</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">3:12:00</td> <td align="right">60</td> <td align="right">1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">3:17:00</td> <td align="right">10</td> <td align="right">1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215);" height="20">John</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215);" align="right">6147</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215);" align="right">3</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">3:01:00</td> <td align="right">104</td> <td align="right">1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">3:10:00</td> <td align="right">1000</td> <td align="right">1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">3:15:00</td> <td align="right">5043</td> <td align="right">1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: 0.5pt medium medium; border-style: solid none none; border-color: rgb(149, 179, 215) -moz-use-text-color -moz-use-text-color; background: none repeat scroll 0% 0% rgb(219, 229, 241);" height="20">Grand Total</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: 0.5pt medium medium; border-style: solid none none; border-color: rgb(149, 179, 215) -moz-use-text-color -moz-use-text-color; background: none repeat scroll 0% 0% rgb(219, 229, 241);" align="right">6264</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: 0.5pt medium medium; border-style: solid none none; border-color: rgb(149, 179, 215) -moz-use-text-color -moz-use-text-color; background: none repeat scroll 0% 0% rgb(219, 229, 241);" align="right">7</td> </tr> </tbody></table>
This is sorta the way it looks like at the moment.. So as you see I have to go by timestamps and break down how many they did in a hour and the number of pcs.
The pivot table grows all day long. I can add code to add between the hours each time I update but I would like to have this done automatically if possible..
I would like to see
John at 4:00:00 did a total of 6147 pcs and 3 transactions
We work 8 hour shifts so it would be nice if the pivot table could do that every hour.
Sorry if my detail is not that great.. But is this possible?
Thanks
