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