Forum Discussion
Solved
Bundle Help
I'm looking for some help with bundles, currently using floor formula The formula I am using is =FLOOR(total hours, hour interval)/hour interval The problem I have is the higher intervals also...
See the attached version.
one more quick question, is it possible to include a modifier for the amount of intervals needed based on a starting hours?
The current option assumes the starting hours is zero, but if a contract starts at say 3700hrs the first interval will be a 4000hr service, not a 500hr. Could this be adjusted to calculate the amount of services based on the starting hours?
| term hrs | interval hrs | amount | starting hrs | ||
| 7000 | 500 | 7 | 3700 | ||
| 1000 | 4 | ||||
| 2000 | 1 | ||||
| 4000 | 1 | ||||
| 6000 | 1 | ||||
See the attached version.
- That is perfect, thank you so much. I've been beating my head for days. Guess its above my skill level