Time sheet help

Rodzoo

New Member
Joined
Oct 13, 2006
Messages
5
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
Joined
Jul 8, 2003
Messages
1,395
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
Joined
Oct 13, 2006
Messages
5
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
 

babycody

Well-known Member
Joined
Jul 8, 2003
Messages
1,395

ADVERTISEMENT

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

Rodzoo

New Member
Joined
Oct 13, 2006
Messages
5
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
Joined
Oct 13, 2006
Messages
5
the answer would be 3 that is the number of my employes in that group.
Thoes large numbers was there employe number.
 

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top