# Time sheet help

#### Rodzoo

##### New Member
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

### Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

#### babycody

##### Well-known Member
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

##### New Member
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

perhaps:

=count(a1:a4)

???

#### babycody

##### Well-known Member

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

#### Rodzoo

##### New Member
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

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

Replies
3
Views
112
Replies
4
Views
86
Replies
15
Views
199
Replies
4
Views
132
Replies
6
Views
101

1,141,679
Messages
5,707,786
Members
421,527
Latest member
Tamiwsw

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back