Hire Shop price structure

[stephensaid]

Hi all,

I've browsed through the forum trying to solve this one, but I doubt it I'll find anything similar.
Maybe you guys can come up with something.

The following is an example product that we hire out:
Tool A
1 to 4 hours - €8.00
up to 1 day - €16.00
Any Extra Day - €16.00
A whole week - €96.00
Week End - €23.00

Note that not all products have the same ratio between the different rates (so I cannot work with a percentage) and not all products have the 4 hour rate.

I am trying to let the user place a request for the tool instead of making an order.
Ideally the user enters the start and end date and time and the system displays the calculated price.

Any workarounds considered.

Looking forward to your input.

Thanks and regards,

Stephen Said
http://www.ideasoftmalta.com