"Albert.Harmse" wrote in message
...
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

I don't understand your problem. AWOL, SICK etc are not numeric, so in any
calculation they are effectively zero.

--
Ian
--