I have attached a sample workbook, if you could take a look please.
With the help and patience of this forum I created a very successful workbook for a local charity who hire out disability equipment.
They would now like to have a different workbook for hiring other items and the conditions are nothing like the other book
There are 3 types of hirers
C = Casual
D = Day
M = Members
Casual, get charged £3 for anything up to 3 hours
Day, get charged £5 for the day or over 3 hours (they are all returned that day, no overnight, so the max would be 9 hours)
M, don't get charged because they pay a subcription
The attached sheet has the following columns
'F' start Time. 'G' End time 'H' Hours hired 'I' Hire Cost
What I would like, if it can be achieved is for the hire cost to be controlled by column 'C'
If you enter 'C' then column 'I' calculates G-F and if under 3 hours charges £3
If you enter 'D' then column 'I' calculates G- F and if over 3 hours charges £5
If you enter 'M' then column 'I' just returns £0.00 because there is no charge.
The price of £3 and £5 would be picked up from Cells M% & M6 because that's a contigency for the future to allow for any price changes, rather than have to change all the formulas
Can it be done? or do you have any better ideas, they are very welcome
Thanks
Bookmarks