• Click here to stay informed regarding app compatibility with Apple's new iOS 15 release.
  • NC Software is having a Black Friday sale event November 26th thru 29th. Use coupon code BF21 at checkout to take 15% off your purchase for eligible products. Visit https://nc-software.com to shop now.

Converting HHMM to tenths for purposes of importing from a csv

harrier1231

New member
Joined
Nov 8, 2021
Messages
2
My airline exports our logbook into csv with our times as HHMM as in 158 is One hour 58 minutes, or 2.0 hours for logging purposes. I'm wondering the best way to import. As it is, I spent hours either adding colon manually to each row or manually converting. There has to be an easier way! (using libreoffice but most excel formulas should translate).

47 = .8
145 = 1.8
558 = 6.0

Thank you all!
 

Eric A.

Senior Support Engineer
Staff member
Joined
Jan 18, 2003
Messages
854
Location
DTW
You need to apply a custom time format to the column in Excel. Excel will show the colon in the time but it will not be able to perform an any calculations with the column.
You will then save the file as a text (tab Delimited) file and then you can import it into Logbook Pro Pro using the correct time format in the import wizard. Logbook Pro will then convert the entries to hours and tenths during the import.

If you continue to have issues please send the csv file and back up (FILE..BACKUP TO FILE) of your Logbook Pro Logbook to us. helpdesk at nc-software dot com
 

harrier1231

New member
Joined
Nov 8, 2021
Messages
2
You need to apply a custom time format to the column in Excel. Excel will show the colon in the time but it will not be able to perform an any calculations with the column.
You will then save the file as a text (tab Delimited) file and then you can import it into Logbook Pro Pro using the correct time format in the import wizard. Logbook Pro will then convert the entries to hours and tenths during the import.

If you continue to have issues please send the csv file and back up (FILE..BACKUP TO FILE) of your Logbook Pro Logbook to us. helpdesk at nc-software dot com
Ok that helped tremendously for the setup, however, the math in the import is wrong. Tenths as used by the legal, the faa legal, and any billable hour world would be such that 1:31 is 1.6. However, it imports at 1.5. There are several of these where it is off.
tenths-conversion-table.png
 
Top