Hi guys

New member and a very new Excel user, looking for some help. I think I may be using this forum quite a bit!

Basically my biggest customer has asked me to produce invoices in excel as opposed to Sage because it works better for them, with this in mind I will have to use excel for everything......The problem is I have no idea about excel, well.......Ive just learnt some basic formulas, ive set up a basic template.....but heres my problem.

My invoice layout is basically like this.

Travel Hours Site Hours Rate Additional Material Total

2.00 2.00 1 £180.00
1.00 1.00 1.5 £135.00

I have different rates for different customers......then I have 3 rates for each of those customer. So If I charge £45p/h to one customer (normal rate) it then becomes 67.50p/h (1.5) and £90.00p/h (2).....depending on the time of call out. You will see above that one call out could incorperate two different rates, depending on arrival and departure time etc.

1) How do I get a value (travel and site hours) converted into £
2) How do I set a specific value for each rate customer, and rate? Can I have a rate saved so i can then select that rate relevant to that customer when inputting?

Any help would be greatly appreciated, im sorry to be a boring noob.....!