Hi
I need to calculate the time worked for the employees on a weekly and
monthly basis, but knowing all employees they are not always at work. So we
use abbreviations like i.e AWOL, SICK exe. What formula will I use to add any
text as zero hours worked.

Any help with this will be greatly appreciated.

Regards

Albert.Harmse