Hello Ventuzians!
THE FORUMS ARE CLOSED!

Please join our discord server HERE!! << click me :D

We are shutting our Ventuz Forum, but don't worry, it will all be archived for you to search in if you have a query. From now on, please add all your comments, questions or observations into our Discord Server

Thanks for the great time - see you on discord!!
Dee, Karol, Daniel and the whoooole Product and Support team!

Excel dd:mm

Q and A about functionality and how to solve a special task for your application.

Moderator: Support

Post Reply
ChrisFlye

Excel dd:mm

Post by ChrisFlye » 21 Nov 2013, 16:45

Hi all,

I'm having a problem reading a cell in excel. It is a time value and In excel it is a custom cell set to hh:mm. Ventuz reads that cell as 0.39166666666666738, which I understand is a way of expressing time universally. How do I convert this to a straight time value? Would it be using 'convert to text'? If so, how do I write the 'format' value to do it?

Thanks
Chris

Post Reply