Help Programming Excel Sheet!

  • Thread starter Thread starter it''''''''sh hardy
  • Start date Start date
I

it''''''''sh hardy

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
 
Hi,

Perhaps you could give a clearer explanation of what your trying to do and
the formula that's giving and error. Someone will help.

Mike
 
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(B1>40,(B1-40)," ") and
SUM the column for total OT hours. YOu could use conditional formatting to
highlight the hours over 40 also.
D
 
You beat me to the "COUNTA()" punch, it was what I was going to suggest,
barring any more info from the OP.
 
Back
Top