flight times with MS Excel ... (again)

[Squawk7777]

I am using MS Excel as my digital logbook. I'd like to add a few features, but I am a novice at best when I comes to MS Excel.

Right now, I have figured out how to add hours and minutes.

I'd like the Excel logbook to show me the hours flown in the last week. How can you program this with Excel?

7 7 7 7

[drauk]

Add a column (you can hide it later if you like) which calculates the number of days from the entry till today.

Then use an IF or a DSUM to add up only hours for rows with the above number < 7.

[MrWoollie]

To add in hours and minutes format the cells you wish as [h]:mm

The square brackets prevent the hours converting to days when you exceed 24.

MrW

[737TG]

Create a new column.

In the seventh row type

=SUM(C1:C7)

C being the column you want to count!

Now, highlight the cells you want the function to be repeated and use CTRL D to "fill down".

You now have a running total of your weekly hours.

Cheers

[drauk]

Alas, I fear these responses may be somewhat confusing, because they don't actually solve your problem. Take a look at this example to see one way to do it. The important bits are in columns C and D.

[Squawk7777]

drauk & co.

Thanks for your replies. One question though, in your example in D3 [=IF(C3<7,B3,0)] what is the significance of ,0 after B3?

7 7 7 7

[ZH875]

D3 [=IF(C3<7,B3,0)]

Read the formula as:

D3 =

If C3<7 is TRUE then the value of D3 is B3

if C3<7 is FALSE the Value of D3 is 0

If you left click on the = sign on the formula bar, it will open a window which explains it.