flight times with MS Excel ... (again)
Thread Starter
Join Date: Aug 2000
Location: formally Alamo battleground, now the crocodile with palm trees!
Posts: 960
Likes: 0
Received 0 Likes
on
0 Posts
flight times with MS Excel ... (again)
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
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
Join Date: Sep 2002
Location: London, UK
Posts: 778
Likes: 0
Received 0 Likes
on
0 Posts
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.
Then use an IF or a DSUM to add up only hours for rows with the above number < 7.
Join Date: Jan 2001
Location: Stansted, UK
Posts: 44
Likes: 0
Received 0 Likes
on
0 Posts
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
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
Join Date: Sep 2002
Location: London, UK
Posts: 778
Likes: 0
Received 0 Likes
on
0 Posts
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.
Thread Starter
Join Date: Aug 2000
Location: formally Alamo battleground, now the crocodile with palm trees!
Posts: 960
Likes: 0
Received 0 Likes
on
0 Posts
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
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
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.
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.