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
Erika, I didn't catch your calculations (Mon to Fri 10 hrs each gives 50 hrs), however you may use SUMIF instead of SUM
- No, don't work on Wednesday, thus the "0" entered\
