Forum Discussion
Solved
Formula help please
I am trying to write a formula that adds time together or an employee sheet, but I would like it to reset whenever a "0" is input. For Example: Adding Monday through Friday, each employee working 10 ...
Hi Erika
That's a tricky one. I've attached a file for you to look at.
I've split it into 2 formulas
The first formula finds where in the row of numbers the first 0 appears
The second formula then adds up the numbers from that point
Hi Erika
That's a tricky one. I've attached a file for you to look at.
I've split it into 2 formulas
The first formula finds where in the row of numbers the first 0 appears
The second formula then adds up the numbers from that point
Nevermind! I figured out a way that it works with those exact formulas! THANK YOU SO MUCH! You saved me from utter craziness.