calculating time multiplying to some amount

Hi all
I want to calculate time multiplying to some amount
For ex:
If customer used system for 15min then we have to charge $5
If customer used system for more than 15min then we have to charge $10
If it is more than 30min and up to 1hour or below 1hour then it should be $15

A B C D
sys-no in-time out-time amount
1 7:50 9:00
2 8:20 9:00
3 3:30 5:30
Formula should be in D column.

Please could any tell me the way and formula to do this one?

You need to define these time rules properly.
First of all your "timeouts" need to be 24hr clock so in example 3, 03:30 should be 15:30 and 05:30 should be 17:30 otherwise your time calculations wont work properly.

It looks like you are saying:

Up to 15 mins is $5
15mins to 30mins is $10
30mins to 1hr is $15

Assuming this is correct

In D1

=C1 - B1 which defines the amount of time worked.

In E1

=IF(D1<=0.010417,5,IF(D1<=0.020833,10,15))


You havent said what happens if its more than an hour