The formula I need help with, would be located in cell C22.
Here's a brief overview of my calculator...
For every 1 hour that I work, it is required that I have 24 minutes of Talk Time.
In the example attached, you can see I made 4 calls - that all lasted 30 minutes each. Which gives me a total of 2 hours of talk time for the day.
Cell C22, should say "24" - but I don't know how to write the formula.
* Please check out how my formulas are interacting which each other. I'm sure that will be the easiest way to figure out what's going on before you provide a possible solution.
If you need anymore information, please don't hesitate to ask!
Thank you in advance!