adherence

Not sure where to even start on this one - hopefully someone can help direct me. I need to look up a person (i.e. Agent: 63517 Acker, James) then from there, find the section called "Total for xxxx" (i.e. Total for 63517 Acker, James), the find "Available and pull/get the Percent in Adherence...

Hi, I have 2 time formats in H:MM:SS AM/PM and I need to calculate in one cell the % adhered to the shift. If someone was scheduled to work 8-5 but actually worked 8:10-5:10, they got their 8 hours in but didn’t work it within the shift. The logic is Adherence = minutes within Aherence /...

Hi, Can a VLOOKUP guru out there help create a formula to fix my problem? I am wanting the 'Target' box to to look at the 'Metric' box and return the value as above. IE; if 'Adherence' is selected then the target value is returned as 95%. Please help :)

Hi All, I am currently working on an adherence project & am a little stuck on a formula for the following Column B holds codes ie, Break Column E holds in duration in that code The formula needs to check column B to check its Break, then if duration is over 00:15:00 to count anything over...