Time sheet help

[Rodzoo]

Hello Listers
I am working on a time sheet and need some help with a formula.
On a cell that would normaly have 40 hours worked .
If that person does not have there 40 hours worked and only came in for 20 hours.
How would I make that calculate outand not give me a negitive number
if they don't work 40 then it would need to subtrack 40and give me a + number?
How would that formuls look
I have tried a few and keep getting a error
Thanks

 

[babycody]

I'm assuming this is used to calculate OT. Try =IF(D10<40,0,(D10-40)*(1.5*$8.50)) Where D10 houses the hours worked, and 1.5 is time and a half.

 

[Rodzoo]

TIME SHEET

Worked great
tHANKS,

How do I make a cell that has a number in it like (10458) only have a value of 1 when occupied.

like if i had cells with
10459
11354
12365
blank cell
and if I do sum of the 4 cell the anwser would be 3

 

[PaddyD]

perhaps:

=count(a1:a4)

???

 

[babycody]

If you were summing these numbers what would the answer be?
10459
19354
12365

 

[Rodzoo]

TIME SHEET

Thank you Varymuch
worked like a charm
I hope I can give back to the list as much as I have received + much more.
Thanks again

 

[Rodzoo]

the answer would be 3 that is the number of my employes in that group.
Thoes large numbers was there employe number.