stevenalvarado
New Member
- Joined
- Jan 10, 2014
- Messages
- 7
Hi guys & girls.
I´ve been reading your forums for almost one month and until now I decided to get on board.
This is what I have, only column A and B will be seen by the rest of the people who will use the Excel file once it is finished.
Column B will have the timestamp via VBA (please take a look at the code, it is working for me though). One more thing, I know nothing about VBA so please bear with me.
What I would need is Column E (MIN) and F(MAX) to give me the Earliest and latest hour of column B only if date in column C is the same of column K that´s because, column K is just comparing information. This is the only idea that I have since I am just beggining with Excel 2010.
As you can see, column C has only the date given by the timestamp. Because it is a timestamp, no ranges can be chosen since different people have different schedules.
One more thing, I need to know how many transactions are being worked per hour, you can see that also it is important to have that information for an average of transactions worked per hour each week and since every week begins in our company each Sunday and ends on Saturday, you will find on the file the idea that I had: look at the transactions work per day and and divide that into the number of hours worked said day.
Hope I made myself clear.
I´ve been reading your forums for almost one month and until now I decided to get on board.
This is what I have, only column A and B will be seen by the rest of the people who will use the Excel file once it is finished.
Column B will have the timestamp via VBA (please take a look at the code, it is working for me though). One more thing, I know nothing about VBA so please bear with me.
What I would need is Column E (MIN) and F(MAX) to give me the Earliest and latest hour of column B only if date in column C is the same of column K that´s because, column K is just comparing information. This is the only idea that I have since I am just beggining with Excel 2010.
As you can see, column C has only the date given by the timestamp. Because it is a timestamp, no ranges can be chosen since different people have different schedules.
One more thing, I need to know how many transactions are being worked per hour, you can see that also it is important to have that information for an average of transactions worked per hour each week and since every week begins in our company each Sunday and ends on Saturday, you will find on the file the idea that I had: look at the transactions work per day and and divide that into the number of hours worked said day.
Hope I made myself clear.