fuel formula

[bhopkins]

Help Required for Mileage expenses

Col G= Total Mileage formula =if(i29="","",i29-h29)
Col H= Opening Meter Reading
Col I= Closing Meter Reading

Col J = Business Mileage
Col k= Private MIleage


The employee have fuel cards and some cards use petrol or diesel, and we need to deduct private mileage from their expenses.

Many thanks
B

[dangelor]

Possibly...

=G29-K29

[bhopkins]

Sorry I have that formula,

What I need is that I deduct the Private Mileage from there expenses, some of them would have petrol cars or diesel cars .

Its to calculate this formula?

BMurray