kaia2001
New member
- Joined
- Sep 5, 2018
- Messages
- 9
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Office Standard 2013
Ok Gurus!
Can this be done? I have a Pivot table that returns the number of orders an employee processes each hour. I want to add a column that will calculate the Unit per Hour each hour as the day progresses. For instance the day starts at 5am hour 1 is 5-6am so the first hour will be 10 orders/1 the second hour will be 15 orders/2 @ 7am , etc... Is this possible? I feel like I may be over complicating this, thus me bringing it to the forum. Thank you all in advance.
Can this be done? I have a Pivot table that returns the number of orders an employee processes each hour. I want to add a column that will calculate the Unit per Hour each hour as the day progresses. For instance the day starts at 5am hour 1 is 5-6am so the first hour will be 10 orders/1 the second hour will be 15 orders/2 @ 7am , etc... Is this possible? I feel like I may be over complicating this, thus me bringing it to the forum. Thank you all in advance.