Hi

Just use =Sum(A1:A10)

It will sum numeric values in the range only.

Regards,
Per

"Albert.Harmse" skrev i
meddelelsen ...
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