I currently have it so lunches are automatically deducted from time clock spread sheet. =SUM(D4-C4)-E4
But if you are absent it calculates a negative time for day throwing off weekly hours. =SUM(F4:F10)
I have such a tried a great many sumif statement to only realize positive numbers but get a error. =SUMIF(A1:A100,">0") etc.
Was wondering if someone had a solution for this problem
First, your first formula does not need to use SUM. Just use this
=D4-C4-E4
Then you can do this to prevent negative numbers:
=MIN(0,D4-C4-E4)
Then your other SUM formulas should work fine.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Still get an Err:509Originally Posted by 6StringJazzer
I think this maybe because I’m dealing with time and not persay numbers
There is no such thing as Err:509. Where are you seeing that?
What are the values in C4, D4, E4 when you get the error? What formula is giving you the error?
It might help to attach your file. See yellow banner at the top of the page.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks