time field export to filemaker issue

  • Thread starter Thread starter Sarnath
  • Start date Start date
S

Sarnath

Help (again :)) please:
My original posting concerned splitting a date/time into 2 fields where
my issue was with the text to column wizard. The solution a user posted
worked- I copied the orig col into a new one and formatted the 1st as a
date, the second, as a time.

When I imported the data into FileMaker, the date transferred
correctly, but the time looks like this:-4293:0':.- or this:
-3536:00:00

I have changed the field definition types in FM to all varieties (date,
time, number, text) but nothing works, so I am left to believe it is
something weird on the excel side?? (I created a macro to do all the
insert new col, copy, format cell, etc. and ran it on the data before
importing to FM.)

Thoughts??
(Thanks!!)
 
Try adding a column in which you convert the time to a text string, then
import that column to the Time field. For example:

=TEXT(B1,"h:mm AM/PM")
 
Back
Top