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 this allocation. If the duration is under 00:15:00 to appear blank?
Is there a formula that would work in both Excel 2003 & 2007 for this?
Any help is much appreciated
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 this allocation. If the duration is under 00:15:00 to appear blank?
Is there a formula that would work in both Excel 2003 & 2007 for this?
Any help is much appreciated