When import excel file, the time column change to be 0.389xxx

HCL Domino Domino Forum
1

Hi everybody~

when i import the excel file to lotus notes, the time column will change to be 0.38XXXX~ how can i do???

actually, after import the excel file to lotus, i want the time column can show the normal time status~ please help me~~

thanks advanced~~~~

from caton

2

Subject: When import excel file, the time column change to be 0.389xxx

You ran into the problem with date/time-formatting.

I solved it by reading the time from the excel-sheet as a string and then convert it using lotusscript date/time functions to the correct Notes time.