Create Pricing Bands

[Char]

Hi,

I need some help working out how i would set price bands so my spreadsheet would know if the worker choses 15 minutes and that service costs £24.00 and if they chose that same service but the worker spent 30 minutes doing it, it would then double to £48.00, I hope that makes sense! I have attached a copy of the spreadsheet so far.

Thanks,

Charlotte

[davegugg]

I don't know much about currencies other than the US dollar, but is twice £24 really £44?

Anyway, I don't see anywhere in your spreadsheet where the actual time used is input. Isn't the result you are looking for Actual Time / Estimated Time * Cost?

[Char]

Hi Dave, Yes that is the result I am looking for, Sorry about the bad maths and explanation!

Thanks

[davegugg]

You can't do calculations on text. You need to change column E on the Work Log sheet and column C on the Price List sheet to display numbers only.