# Fuel Burn Formula

1. ## Fuel Burn Formula

Fuel burn.xlsx

Hi,

im trying to calcultae the fuel burn for one of our Aircraft depending on how much is the block time

so..
hours:
1st 3000lbs
2nd 2900lbs
3rd 2100lbs
4th 2100lbs
5th 2100lbs
6th 2100lbs
7th 2100lbs

if i fly 1 hour.. .then it will be 3000 lbs fuel burning
if i fly 1.5 hr it will be 1hr*3000 lbs + .5hr * 2900 = 4450 lbs .
if i fly 4.7hrs it will be ... 1hr*3000lbs + 1hr*2900lbs + 1hr*2100lbs + 1hr*2100lbs +.7 hr* 2100lbs = 11570lbs of fuel burning.

now how can i make a formula to under stand that each hour should be multiplied by each cell and sum it up in one cell ?

thank you

regards,
Hani

2. ## Re: Fuel Burn Formula

Fuel%20burn(1).xlsx

Doe this do what you want it to do?

hi..

regards,
JRD

4. ## Re: Fuel Burn Formula

Try this in E3 and copy down:
Formula:

Edit: I did convert your data from text to numbers.

5. ## Re: Fuel Burn Formula

Beaten to it this time, Hani. But the same sort of solution...

6. ## Re: Fuel Burn Formula

All,

JR Dhona...thats exactly what i want . i did not understand anything from that formula . but its working lol. do u have a link on youtube or anywhere else explaining this ?

Crooza. i like what you have done but its a bit complicated as you added extra coloumn.also , when you multiply 1.5 you multiply first hour with with first hour of fuel burn. for the .5 hr , you need to multiply it by the second hr of fuel burn not the first hour

JACC...thank you . but the answer gave me 0 //

7. ## Re: Fuel Burn Formula

thx Glenn!!! awesom bro!!

8. ## Re: Fuel Burn Formula

Originally Posted by guitarist00

JACC...thank you . but the answer gave me 0 //
Check out the workbook I attached in post #4 instead.

9. ## Re: Fuel Burn Formula

thx Jacc . working perfectly

10. ## Re: Fuel Burn Formula

He he... you can tell this was a fun problem to solve, so many different but correct answers in a short time.

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

#### 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