Aloha!



I am a helicopter pilot and am trying to create some sort of running total to implement my own fatigue management system to ensure i'm not overflying myself or what not.

I currently use the attached sheet to log my hours. Column 'F' of the sheet is where I enter how many flight hours for the day and column 'G' totals the hours (cumulative total). I would need to get the running total using the numbers in column 'F' i just can't figure out the formula or if i'll need to create a master sheet or something. This has been mind boggling for the past month and now I'm seeking further assistance.

I know excel but not as well as i'd like and have been having issues trying to come up with a 30-day running or rolling total over various sheets and sometimes workbooks when you get to the end or beginning of the year.

I would greatly appreciate if someone could show or explain to me how to go about doing this.

Attached Files

30 Day Running Total Master Duty Log Shell (OAHU).xls (138.5 KB, 22 views)