Formula Help - Remaining Hours To Be Worked In A Term, Equally Spaced Out Monthly
You've always been good to me. I'm hoping to get across the finish line for a formula I've been working on.
Here's what I have:
* Start Date, End Date, Working Days within that range (could be one week, could be ten years)
* Remaining Hours (total hours necessary to be worked within the Start & End Date)
I need a formula that uses the above fields to say "if X hours remain to be worked within the range, how many hours would that work out to for May 2023, June 2023, July 2023 (through the end of the term).
Help Article Resources
Check out the Formula Handbook template!