After downloading the excel, I simply changed the Off/On column headers to Out/In so it would calculate Night time. I also requested an hours log from DCA CPO. That log only has total time for each leg. So you cannot really use it if you want Out/In times. But one helpful thing it does have is a Landing column. So I equated Landing with Pilot Flying. I copied and pasted the Landing column to a new column on the excel file and called it Pilot Flying. In another added column called “actual IMC” I took a very conservative estimate of actual IMC for each leg. It is probably not 100% accurate but I know it definitely underestimated my actual IMC. Then, in a final column I added an ILS, RNAV, or Visual approach for each PF LEG based on destinations and a WAG. For example, I usually fly the RNAV in KSAN because there’s no ILS. That’s about the best I could do to get some history back.

I never should have stopped logging time. I stopped logging time when some CA told me it was a waste of time because I was “furlough-proof” after 4 years. Ha ha!!!