2 Replies Latest reply on Jun 14, 2013 10:38 AM by Emily Mueller

    Sum from threshold

    Emily Mueller

      Good morning,  I'm looking for a solution to sum shift lengths after a 34 hour break.  I have a calculated field that shows the word "Reset" after a 34 hour break, but I can't figure out how to sum the shift lengths after that "Reset" threshold.  I'm assuming a lookup formula is what I will end up with, but how do I count the offsets to that "Reset" threshold?  I have attached a packaged workbook, and I appreciate any help that can be offered!