time field export to filemaker issue

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")

Sarnath wrote:
> 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!!)
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html