Excel 2007 : How to apply 17.5% VAT to a certain row label on a pivot table?

[Monique Rebanks]

Hello
My pivot table relates to certain activities, minutes spent etc.
For each activity I have to calculate the hour rate i.e £25 according to the amount of minutes spent on it but on one of those activities I have to apply 17.5% VAT as well as the hour rate i.e £25
On the attached pivot table you can see the label 'record keeping VAT applies' and 'report writing VAT applies' It is from those two labels that I have to do the calculation
I am also hoping to create a template so that evertime 'record keeping or report writing VAT applies comes up, this formula stand.

I am completely new to this and hope you can help me.

Monique

[martindwilson]

cant you just say in the amounts column put something like =IF(ISNUMBER(SEARCH("vat",C1)),(D1/60)*25*1.175,(D1/60)*25) where d1 is the total minutes charged for you charge for. then use that instead

[Monique Rebanks]

Thanks Martin.
I shall try it out tomorrow. I hope it works.
Much appreciated