How do I convert elapsed time since 1904 to mSec.

[acalmeyn]

I'm trying to get a time stamp that is good to a mSecond , that can be put into excel. When converting the seconds from Jan 1904 I've noticed that it only updates every 15msec.

[Brett_B.]

Try converting the time stamp using the "to extended precision float" found on the numeric conversion palette.

-Brett

[acalmeyn]

I tried to convert to "to extended precision float" and still the same result???


1904 Time -----------Elapsed time
3193763097.3750000---0
3193763097.3750000---0
3193763097.3899900---0.014989853
3193763097.3899900---0.014989853
3193763097.4059900---0.030990124
3193763097.4059900---0.030990124
3193763097.4059900---0.030990124
3193763097.4059900---0.030990124
3193763097.4059900---0.030990124
3193763097.4210000---0.046000004
3193763097.4210000---0.046000004
3193763097.4210000---0.046000004

[acalmeyn]

Kevin Price has solved the problem see thread.
http://forums.ni.com/ni/board/message?board.id=170&message.id=111477

He took a msec time and added it to the elapsed time stamp