Logten Users?
#11
Gets Weekends Off
Thread Starter
Joined APC: Mar 2018
Posts: 100
For anyone that is struggling with this, I did find something that works, it is kind of clunky and I'm sure excel or programmer wizards can find an easy way to do this.
Download logbook from SWAPA in CSV, I adjust values to be separated by comma. In excel, deleted deadheads, then took the block time column and used
down the whole column. This gives flight times that logten will read. After that, define the values when logten gives the prompts. My issues after that, was any IN or OUT time that was after midnight was not entered in logten, so anything like 0001 or 0050 was not populating. I'm sure I could have gone back to fix that in excel but ended up doing that manually.
Hope that helps anyone else out there in future land who is too cheap to pay for the subscription and is still living off the lifetime software purhcase.
Download logbook from SWAPA in CSV, I adjust values to be separated by comma. In excel, deleted deadheads, then took the block time column and used
=--TEXT(G2,"00\:00")
Hope that helps anyone else out there in future land who is too cheap to pay for the subscription and is still living off the lifetime software purhcase.
#12
Gets Weekends Off
Joined APC: Jan 2018
Position: CA
Posts: 183
I am about 5 years behind on my logbook as well. I have the actual flight time, but what is everyone doing for logging past approaches, actual IFR time, night, etc...? Obviously I am not able to recall all that information. Is that even needed to be in our logbooks for the purposes of interviewing elsewhere? Or, are they just looking for total time PIC/SIC, turbine etc? Sorry, didn't think I'd be updating my logbook either. Thanks
#13
Gets Weekends Off
Joined APC: Oct 2006
Posts: 2,912
I am about 5 years behind on my logbook as well. I have the actual flight time, but what is everyone doing for logging past approaches, actual IFR time, night, etc...? Obviously I am not able to recall all that information. Is that even needed to be in our logbooks for the purposes of interviewing elsewhere? Or, are they just looking for total time PIC/SIC, turbine etc? Sorry, didn't think I'd be updating my logbook either. Thanks
#14
Gets Weekends Off
Thread Starter
Joined APC: Mar 2018
Posts: 100
I am about 5 years behind on my logbook as well. I have the actual flight time, but what is everyone doing for logging past approaches, actual IFR time, night, etc...? Obviously I am not able to recall all that information. Is that even needed to be in our logbooks for the purposes of interviewing elsewhere? Or, are they just looking for total time PIC/SIC, turbine etc? Sorry, didn't think I'd be updating my logbook either. Thanks
#16
Gets Weekends Off
Thread Starter
Joined APC: Mar 2018
Posts: 100
For anyone that is struggling with this, I did find something that works, it is kind of clunky and I'm sure excel or programmer wizards can find an easy way to do this.
Download logbook from SWAPA in CSV, I adjust values to be separated by comma. In excel, deleted deadheads, then took the block time column and used
down the whole column. This gives flight times that logten will read. After that, define the values when logten gives the prompts. My issues after that, was any IN or OUT time that was after midnight was not entered in logten, so anything like 0001 or 0050 was not populating. I'm sure I could have gone back to fix that in excel but ended up doing that manually.
Hope that helps anyone else out there in future land who is too cheap to pay for the subscription and is still living off the lifetime software purchase.
Download logbook from SWAPA in CSV, I adjust values to be separated by comma. In excel, deleted deadheads, then took the block time column and used
down the whole column. This gives flight times that logten will read. After that, define the values when logten gives the prompts. My issues after that, was any IN or OUT time that was after midnight was not entered in logten, so anything like 0001 or 0050 was not populating. I'm sure I could have gone back to fix that in excel but ended up doing that manually.
Hope that helps anyone else out there in future land who is too cheap to pay for the subscription and is still living off the lifetime software purchase.
- Download csv
- Open in google sheets
- Delete DHDs
- Delete DHD column
- Delete top 6 rows
- In far column, add new column for new block time, enter formula =TIMEVALUE(TEXT(G2,"00\:00"))
- Drag formula down
- Change format to time --> duration
- Select column values, paste as values only in block column
- Export back to desktop, upload to logten
Thread
Thread Starter
Forum
Replies
Last Post