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

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

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,144,366
Messages
5,723,942
Members
422,527
Latest member
TotalBeginner201

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