Need to make a rate table... Please help

[cmclark]

Hello. I need to figure out how to make a rate table where the rate changes and depends on time. For example,

if 0-1 hours cost 1 dollar
if 1-2 hours cost is 4 dollars
if 2-3 hours cost is 7 dollars
if 3-4 hours cost is 10 dollars
if 5-24 hours cost is 15 dollars

the problem that I am finding is, if, for example the time price I need to calculate is 49 hours. How do I make a formula for the two 24 hour days and the additional 1 hour price. Thank you so much. I have been at this for days!

Christina

[wenqq3]

Please Login or Register  to view this content.

Put A1=49, then formula at B1.
i modified your rate,
>0 ,<=1 ~1
>1, <=2 ~4
>2, <=3 ~7
>3,<=5 ~ 10
>5,<=24 ~15

[wenqq3]

Please Login or Register  to view this content.

Edited. Try this.