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
=E3-D3
=SUM(D4-C4)*24
=MOD(D6-C6,1)*24
I'm not getting the results I'm expecting. As a result the incremental billing formula
=IF(F3>=2,50,IF(F3>=1.5,25,IF(F3>=1,20,IF(F3>=0.5,16,12))))
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