Excel dd:mm
Posted: 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
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