Reading TimeStamp from Excel sheet

[sinan.ismael@rub.de]

Hi everyone, I am trying to get data from an Excel sheet to LabVIEW but I get the value of Timestamp as number, 45111.

I usually faced this when I open a CSV-File in Excel.

I tried to select/deselect 'Use 1904 date system in Excel' but nothing happened

Maybe someone can help?

Attached is a screenshot of my code and Excel sheet

Thank you

Sinan Ismael.

[ZYOng]

See Formatting LabVIEW Date and Time Data for Microsoft Excel

[LVNinja · Accepted solution]

Check this post, how to convert Excel date into LabVIEW date formats.

They use different date systems. 

LabVIEW to Excel (there is some explanation) https://forums.ni.com/t5/Example-Code/Convert-Excel-Time-to-LabVIEW-Time/ta-p/3996348

Excel to LabVIEW - https://forums.ni.com/t5/Example-Code/Convert-Excel-Time-to-LabVIEW-Time/ta-p/3996348

[sinan.ismael@rub.de]

Ok thank you.

I hv to read the timestamp as float.