Converting HHMM to tenths for purposes of importing from a csv

[harrier1231]

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.]

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]

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.

 

[Neal Culiner]

The time chart that is used is the same as used by the US Air Force. Yes, there are different time conversion charts out there but this is what Logbook Pro uses.