topic-35237

Posts: 1195

Joined: Mon Oct 17, 2005 05:41 AM

Reading Excel date-time custom format
Posted: Mon Feb 05, 2018 06:54 PM

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

Posts: 1195

Joined: Mon Oct 17, 2005 05:41 AM

Re: Reading Excel date-time custom format
Posted: Mon Feb 05, 2018 07:51 PM

Found it...
TTOS()

FiveTech Support Forums