[Dx4win] Custom import - time transfer problem

Martin Ellis [email protected]
Sun, 12 May 2002 22:01:15 +1200


[email protected] wrote:

> Hello,
> I am transferring my hand written logs to DX4WIN using a space delimited 
> Excel file (*.PRN) and the custom import feature.  All data is transferred OK 
> except the time.  The colon separating HH:MM is replacing the 2nd digit from 
> the left...e.g., 1757 is 01:57, 1823 is 01:23, 2219 is 02:19 and so on.  I 
> have the "Time" position starting 1 space to the left and RecLen is 5 (can't 
> be changed).  


Hello Stokley

When I edit a custom import filter, and choose the TIME field, I get 
three boxes:  Position, Length and Type.
If you click on Type you get a choice of:
Length 5   Type HH:MM
Length 4   Type HHMM
Length 6   Type HHMMSS

If your spreadsheet has a colon in the timme, choose HH:MM and start the 
field in the correct position on the first digit- I think you have what 
you want.

Regards,

Martin ZL1ANJ