Page 1 of 1

Reading Excel date-time custom format

PostPosted: Mon Feb 05, 2018 6:54 pm
by Marc Vanzegbroeck
Hi,

I receive an excel-sheet from an Third party program with a cell of custom format
jjjj-mm-dd uu:mm:ss,000 (in English yyyy-mm-dd hh:mm:ss,000)

If I read it with oSheet:Cells( rij, kolom ):Value , I only get the jjjj-mm-dd.
How can I get also the time?

Thanks

Re: Reading Excel date-time custom format

PostPosted: Mon Feb 05, 2018 7:51 pm
by Marc Vanzegbroeck
Found it...
TTOS() :D