+ Reply to Thread
Results 1 to 3 of 3

fuel formula

  1. #1
    Registered User
    Join Date
    08-28-2009
    Location
    Dublin
    MS-Off Ver
    Excel 2003
    Posts
    2

    fuel formula

    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

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    1,554

    Re: fuel formula

    Possibly...

    =G29-K29

  3. #3
    Registered User
    Join Date
    08-28-2009
    Location
    Dublin
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: fuel formula

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1