Calculating days formula Problem

[MSconfusedX]

Hey there,

I have a worksheet that calculates employers attendance.
For instance,

Cells from B7 to AE7 are divided into 30 days of the month, and in each cell the coordinator should fill in the number of hours the employer worked.
Cell AF calculates total number of hours
Formula:=SUM(B7:AE7)
Cell AG calculates number of days worked
Formula: =COUNTIF(B7:AE7,">0")

I have been trying to find a formula that would be put in Cell AG in which If the number of hours were more than 5 from cells B7 to AE7 it would count it as 2 days of working.

Is it possible, I imagine it with an if condition however, i'm not that expert with Excel.

 

[MSconfusedX]

I could do it for only one cell. Formula: =IF((B13)> 5,COUNTIF(B13:AE13,">0") + 1,COUNTIF(B13:AE13,">0"))

 

[Trouttrap2]

i think this is what you want
=COUNTIF(B7:AE7,">5")+COUNTIF(B7:AE7,">0")

it takes your formula and counts each cell >0 and then counts those cells again if they are >5.

 

[Rick Rothstein]

Wouldn't just adding cells with hours over 5 to the value you now have to what you want?

=COUNTIF(B7:AE7,">0")+COUNTIF(B7:AE7,">5")

 

[MSconfusedX]

Thank you sooo much ... !