My contract works on bankable time and I would like to be able to how much time I have rather than have to add it up.
The number of hours is in cell E.
Currently I have the formula =SUMIF(E:E,">7"), but I want to have it calculate so the sums of the time over 7 hrs shows up, not the overall sum of hours worked.
So if I worked 8 hours for 3 days, I want to be able to display 3, not 24.
Bookmarks