Results 1 to 9 of 9

Formula to calculate Fuel Consumption

Threaded View

  1. #1
    Registered User
    Join Date
    02-02-2008
    Location
    Tirana, Albania
    MS-Off Ver
    MS Office 2016
    Posts
    21

    Help with Calculating Fuel Consumption

    I need some help in calculating automatically the fuel consumption per 100 kms in a worksheet that contains 31 rows (days of the month) and four columns as follows:
    1. Date (representing each day of the month)
    2. Fuel Tank filling in litres (usually shows 3-4 fillings in different days of the month)
    3. Kilometres Reading at the moment of fuel tank top-up
    4. The formula column, which needs to calcualate automatically the fuel consumption/100 kms whenever there are new entries in columns 2 and 3 as shown above.

    Normally to calculate the fuel consumption/100 kms is:
    x= litres x 100 kms / kms done

    The kms done is calcualted by deducting the Current Kms Reading from the previous Kms Reading.

    I have attached a zipped excel file as an example.

    I would appreciate your help

    Thanx
    Attached Files Attached Files
    Last edited by Biancodi; 02-02-2008 at 03:11 PM.

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