• We've completed testing of iOS 14. Logbook Pro has no issues observed. APDL's only issue is the Weather Map is crashing. We are working on an update for the crash at this time.

Import Formating

schulkeha3

Well-known member
Joined
Nov 21, 2001
Messages
45
Location
Canton, Michigan, United States
Can anybody tell me how to convert a CSV time cell formated as hhmm to mm/dd/yyyy hh:mm in EXCEL? All my OUT/IN times in my CSV file display as either hmm or hhmm. A different column contains the date in mm/dd/yyyy./forums/emoticons/confused.gif
 

Neal Culiner

Founder, President
Staff member
Joined
Nov 14, 2001
Messages
12,642
Location
VA
I'm sorry but I personally don't have the answer to this. Maybe someone else does. However, 'if' Excel recognizes your format as a Date/Time, you should be able to manually set the format to what you desire.

Neal Culiner
NC Software, Inc.
support@nc-software.com
 

schulkeha3

Well-known member
Joined
Nov 21, 2001
Messages
45
Location
Canton, Michigan, United States
I've tried four times to import a CSV file. Everything procedes without error messages, but there are no results from the import. No new entries appear in the logbook. I attached a copy of the CSV file I'm using. /forums/emoticons/frown.gif
 

Neal Culiner

Founder, President
Staff member
Joined
Nov 14, 2001
Messages
12,642
Location
VA
schulkeha3 said:
I've tried four times to import a CSV file. Everything procedes without error messages, but there are no results from the import. No new entries appear in the logbook. I attached a copy of the CSV file I'm using. /forums/emoticons/frown.gif
I successfully imported your data so I was able to verify the Import Wizard is working as designed. I imported your 'Block time' field into 'Duration' confirm this is what you did as well? Secondly, please make sure you are using 1.6 Build 226 available as a free update from www.logbookpro.com.

Neal Culiner
NC Software, Inc.
support@nc-software.com
 
Top