Calculating cost

Okay this is probably easy pickins for those who actually know Excel. But for those of us struggling to learn - any help is appreciated.

Problem - billing spreadsheet for prisoner fee.

1 - 8 hrs = $55
9 - 24 hrs = $55 + $65 or $120
Anything over 24 hrs - $65 for each additional (24 hrs) ($185)

So if you were locked up for 6 hrs it is $55. If you were locked up for 18 hrs it is $120. If you were locked up for 28 hrs it is $185. And if you were locked up for 49 hrs it is $250.

Cell F5 contains number of hours locked up - I would like cell I5 to calculate the cost of the stay.

I am proud of myself for figuring out the date and time subtraction - but this part has me stumped.

Thanks in advance

Using embedded IF,

I5: =IF(F5<=8,55,IF(F5<=24,120,185+(65*INT((F5-24)/24))))

or... =IF(D8<25;LOOKUP(D8;{0;9};{55;120});120+65*INT((D8-1)/24)) (edited)

(edited2: Use DQ INT instead of ROUNDDOWN)

=if(and(f5>=1,f5<=8),55,if(and(f5>=9,f5<=24),120,if(f5>24,120+(floor(f5,24)/24)*65,"")))
hmm lost that race! and prob used to many ands
but three diferent ways of calculating > 24 interesting that
edit
ah its now dropped to 2

Don't forget to make your thread [solved]