Excel buffer - time format

mpudja

Hy everyone,

I have TempExcelbuffer and when I read one cell from file, instead value in time format i get value in number(general).
For example:
In excel file I see 12:30:00 but when I read it with excelBuffer."cell value as text" i get value 0,523xxxxxxxx.

I try with Excelbuffer.NumberFormat = 'h:mm:ss' but it's not working ?

Does anybody can give suggestion ?

nickadrian

Create a variable with Time data type. e.g., vTime
On your code, add the following:

EVALUATE(vTime,ExcelBuffer."Cell Value As Text");

mpudja

I try that and it's not working, so because I didn't succeed i separate hours and min(each value in own column in excel)