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