30 Day Running or Rolling total (Multiple Sheets/Workbooks)
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.
|