take_that
15th Apr 2011, 22:09
Hi guys,
Requiring a little help from those Excel boffs amongst us....
I'm using my own created Excel document. It works fine but I'm trying to refine it a little. I've a basic - intermediate knowledge of Excel.
My logbook has a number of columns including aircraft, date, departure, arrival, block times. I'd like to try and keep on top of my overtime which is triggered when my total block hours over a 28 day period exceeds 74 hours.
I've found part of a possible solution but drawn a blank from being able to proceed further. So far I've used the TODAY() function and TODAY()-28 to give me a 28 day range.
I know the VLOOKUP function but can fathom out how to use the TODAY & TODAY-28 to be applied in this query to get the cumulative total block hours over this range.
If that wasn't complex enough, I would also like to draw a graph over the last 3 months to show a running 28 day block hour total for any given day over a 3a month period.
What advise can anyone lend on this subject? Better still are there any sample websheets that I can view which has this feature?
Thanks for any info
Requiring a little help from those Excel boffs amongst us....
I'm using my own created Excel document. It works fine but I'm trying to refine it a little. I've a basic - intermediate knowledge of Excel.
My logbook has a number of columns including aircraft, date, departure, arrival, block times. I'd like to try and keep on top of my overtime which is triggered when my total block hours over a 28 day period exceeds 74 hours.
I've found part of a possible solution but drawn a blank from being able to proceed further. So far I've used the TODAY() function and TODAY()-28 to give me a 28 day range.
I know the VLOOKUP function but can fathom out how to use the TODAY & TODAY-28 to be applied in this query to get the cumulative total block hours over this range.
If that wasn't complex enough, I would also like to draw a graph over the last 3 months to show a running 28 day block hour total for any given day over a 3a month period.
What advise can anyone lend on this subject? Better still are there any sample websheets that I can view which has this feature?
Thanks for any info