Thanks!!! That's exactly what I needed!!!

Much appreciated

"Brown Recluse" wrote:

Not sure if this is what you want: but, if the names appeared in A1, A2, A3,
A4 and A5 and you wanted to count the names of those that have OT you could
use =counta(A1:A4). Or you could use a formula that highlights any hours
over 40 hrs, such as if the hours were in Column B =if(B140,(B1-40)," ") and
SUM the column for total OT hours. YOu could use conditional formatting to
highlight the hours over 40 also.
D

"it''''''''sh hardy" wrote:

So I'm creating an excel shee for work to calculate OT in my store, but am
having an issue with formatting, here is what I have:

Employee Name
Employee Name
Employee Name
Employee Name
Employee Name
(Total Number of employees with OT)

But because there is names not numbers it is giving me an error... Any
suggestions?

Thanks