Thank you for taking the time to review and maybe assisting in this request.
I need some help.
I'm trying to calculate the time to bill customers from when they enter to when they leave based on set billing increments
0.5 hours = $12
1.0 hours = $16
1.5 hours = $20
2.0 hours = $25
A Day Pass = $50
In the sheet attached I've tried the following formulas
I'm not getting the results I'm expecting. As a result the incremental billing formula
is not working either.
I'm obviously doing something wrong here and missing what it is.
Any help I can get would be greatly appreciated