david gabra
Member
Hello,
I would appreciate your help with the following:
Assuming I have a table with ID #, date and hours per date as follows:
I would like to know if there were any employees who recorded 9 hours for five consecutive days pr or more (business days i.e. Monday to Friday) - it must be business days.
1) so if a employee charged 3 days 9 and 1 day 2 and the next day 9 - this is no good
2) only consecutive days of 9 hours per days for business (so Wednesday, Thursday, Friday and Monday and Tuesday - -great
-----> output
I would like to create a table which would present per ID #, the maximum count of consecutive days with 9 hours in each day. If there is a weekend in between than the count should skip the weekend. [see excel for the example]
I hope that someone can help me with the problem. I am totally stumped, and very very key to exclude Saturday and Sunday form the analysis.
I have attached an excel with the sample data and of course example of the desired results. I have added scenarios that should work and those that should not, based on the criteria above.
Thank you to anyone who can solve this for me, and provide me with the excel logic to this, - please updated the table to show how
Many thanks once again. I hope my explanation was clear. I have googled and tried - but with little or no success.
Now over to the experts
I would appreciate your help with the following:
Assuming I have a table with ID #, date and hours per date as follows:
I would like to know if there were any employees who recorded 9 hours for five consecutive days pr or more (business days i.e. Monday to Friday) - it must be business days.
1) so if a employee charged 3 days 9 and 1 day 2 and the next day 9 - this is no good
2) only consecutive days of 9 hours per days for business (so Wednesday, Thursday, Friday and Monday and Tuesday - -great
-----> output
I would like to create a table which would present per ID #, the maximum count of consecutive days with 9 hours in each day. If there is a weekend in between than the count should skip the weekend. [see excel for the example]
I hope that someone can help me with the problem. I am totally stumped, and very very key to exclude Saturday and Sunday form the analysis.
I have attached an excel with the sample data and of course example of the desired results. I have added scenarios that should work and those that should not, based on the criteria above.
Thank you to anyone who can solve this for me, and provide me with the excel logic to this, - please updated the table to show how
Many thanks once again. I hope my explanation was clear. I have googled and tried - but with little or no success.
Now over to the experts