Paul Harris
New member
- Joined
- Feb 20, 2003
- Messages
- 3
Neal,
Thank you for your prompt reply to my first post, and thank you for your accessibility. This will undoubtedly lead me into your camp.
However, I have a couple of questions concerning an import attempt, because believe it or not, I have forty years of flying in an Excel spreadsheet.
I was impressed to find that the field assignments accounted for separate FROM and TO airports, but I am still hesitant about both airports in a single routing field. Can I query or filter the logbook to find out how many times or how recently I have landed in DCA?
My spreadsheet had OUT and IN in a date-time format, but I had to duplicate the OUT field to import into the DATE field as well. No big deal, but allowing a field on the source to be imported into more than one field would have been less work.
I also linked the DURATION field to a Time field in the spreadsheet, but after the import the DURATION field was empty. I thought, perhaps, that auto-calculation of that field might be interferring, but found no way to turn it off, only change the source from OUT/IN to OFF/LAND. Or, after importing the OUT and IN times, is there a way to have the DURATION calculated from them without having to select and save each record? Am I missing something here?
Thanks,
Paul
Thank you for your prompt reply to my first post, and thank you for your accessibility. This will undoubtedly lead me into your camp.
However, I have a couple of questions concerning an import attempt, because believe it or not, I have forty years of flying in an Excel spreadsheet.
I was impressed to find that the field assignments accounted for separate FROM and TO airports, but I am still hesitant about both airports in a single routing field. Can I query or filter the logbook to find out how many times or how recently I have landed in DCA?
My spreadsheet had OUT and IN in a date-time format, but I had to duplicate the OUT field to import into the DATE field as well. No big deal, but allowing a field on the source to be imported into more than one field would have been less work.
I also linked the DURATION field to a Time field in the spreadsheet, but after the import the DURATION field was empty. I thought, perhaps, that auto-calculation of that field might be interferring, but found no way to turn it off, only change the source from OUT/IN to OFF/LAND. Or, after importing the OUT and IN times, is there a way to have the DURATION calculated from them without having to select and save each record? Am I missing something here?
Thanks,
Paul