Timetable problem
Maybe this will put some light on my prob. We have a "time in" and "time out"
Row for every day of the month ( Row 1 & 2) with all the names in Column A.
Lets say Mr Harmse worked in Jan the following shifts. on the 1st Jan (B3) 7
and (C3) 17. 2nd Jan (D3) 7 and 17 (E3) on the 3rd Jan (F3) "AWOL" and
"AWOL"(G3). We used replace the "Awol" with 0 and do a simple calculation of
=(C3-B3)+(E3-D3)+(G3-F3). but as soon as there is text in the row it gives a
#value! error. What formula can I use to calculate the hours worked?
Please Help
Albert.harmse
"Per Jessen" wrote:
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
.
|