sum formula

[ADIB]

Hi all
please help
A B C D E F G Need Answer
10 10 8 A 10 11 12 13

please help me how can i make formula for above i need calculate overtime ie
after 8 hours

Regards
Adeeb Husain e-mail- (e-mail address removed)

 

[Bob Phillips]

Try this formula

=SUM(IF((ISNUMBER(A2:G2))*(A2:G2>8),A2:G2-8))

it is an array formula, so commit with Ctrl-Shift-Enter, not just Enter

 

[Mike H]

Try

=SUM(IF(ISNUMBER(A1:G1),MOD(A1:G1,8)))

This is an array formula which must be entered with CTRL+Shift+Enter and NOT
'just enter. If you do it correctly then Excel will put curly brackets around
'the formula{}. You can't type these yourself. If you Edit the ranges
'then you must re-enter as An array

Mike

 

[CurlyDave]

Hi all
please help
A   B   C   D   E   F    G          Need Answer
10 10  8   A   10 11  12                13

please help me how can i make formula for above i need calculate overtimeie
after 8 hours

Regards
Adeeb Husain e-mail- (e-mail address removed)

If the max weekly hour are 48 then
=SUM(A1:F1)-48
if it's 8 hrs max per day then
=IF(A1>8,A1-8,0)+IF(B1>8,B1-8,0)+IF(C1>8,C1-8,0)+IF(D1>8,D1-8,0)+IF
(E1>8,E1-8,0)+IF(F1>8,F1-8,0)

 

[Mike H]

As an afterthought you may also want to consider this in case on a day less
then 8 hours is worked

=SUM(IF(ISNUMBER(A1:G1),ABS(A1:G1)-8))

also an array

Mike

 

[Khoshravan]

If I have understand you correctly, in row 3 you can type: A3=A2-8 and drag
the formula right side to get for all cells. This will give extra hours. How
ever I can't understand the A in row two between 8 and 10. Is it a mistype or
has other meaning?

 

[ADIB]

Hi Bob, Thank you very much. you save my time what i spent every month.
Thanks & Regards
Adeeb Husain

 

[ADIB]

Hi Bob, Thank you very much for your reply.i saved my time what i spent every
month.
Regards
Adeeb

 

[ADIB]

Hi Mike,Thanks for your post its very helpful to me .you save my time what i
spent every month.
Regards
Adeeb

 

[ADIB]

Hi Mike,Thanks for your post its very helpful to me .you saved my time what i
spent every month.
Regards
Adeeb

 

[ADIB]

Hi Mike,Thanks for your post its very helpful to me .you saved my time what i
spent every month.
Regards
Adeeb

 

[ADIB]

Hi Mike,Thanks for your post its very helpful to me .you saved my time what i
spent every month.
Regards
Adeeb