Quote:
Originally Posted by Mazzaropi
-------------------------------------------------------------------------
Dear SalienteAnimal, Good Morning.
I couldn't understanding well your explanation.
Could you modify the original worksheet I sent you, puting one example that what you want now in a clear way?
I believe that this will easier the understanding and solution process to your necessity.
You can use the same procedure that I used to save and share the worksheet.( www.4shared.com).
I waiting your answer. |
Hello Again Mazzaropi,
I finally go the link to work, for some reason it had a bracket and / in the link that wasn't meant to be there. I have uploaded the file to
http://www.4shared.com/file/d8u4Ee8a...port_2011.html.
Here's a description of the file:
DATA_SHEET - Data extracted to evaluate
- Column 15 - Staff Time Adjusted (Q)
Used to evaluate the shift times, i.e Between 06:00:00 and 06:30:00, Between 08:00:00 and 08:30:00, and 09:00:00
- Column 16 Break Time Adjusted (R)
Used to evaluate the break times, i.e 00:33:00 and 01:03:00
Monthly_Adherence - Where the initial formula you supplied is being used.
Weekly_Adherence - Weekly Consolidation of the Monthly sheet.
Do you need any additional information from me?
Thanks,