Getting the wrong data when using “Excel Get Worksheet” vi in the MS report generation tool kit

[dksys2000@yahoo.com]

 

When using the “Excel Get Worksheet” vi in the MS report generation tool kit most of the data I correct the date data is all messed up.

 

In the EXCEL file its 7:06:47 AM  But the vi returns 0.296377314814815

 

Thanks

 

Dan

[Jeremy_B]

Hi,

Can you give more details on how the data is formatted in Excel?  Are you just reading string data from the spreadsheet?