Change Excel Value General to Time

[aliaga (Ali Aga Mustofa)]

Hello All,

first, sorry im asking here.
so i have excel file that the x column being filled with time but the type format in general, ex : 13:10

but i want that column x are set with value 13:10 with format time, so i could process it using robot.

any idea?

Thankyou

[mitesh_parmar]

@aliaga

When Reading Excel in Excel Application scope use “Presever Format” option.
It will read as format set in Excel.

[aliaga (Ali Aga Mustofa)]

Hello @mitesh_parmar,

could you give some sample workflow/screenshoot in where i have to use that Presever Format

Thankyou

[mitesh_parmar]

@aliaga

When Reading Excel in Excel Application scope use “Presever Format” option.
It will read as format set in Excel.

[aliaga (Ali Aga Mustofa)]

Hi @mitesh_parmar,

ive try it but it still doesnt work.

output

Output i want :

Thankyou

[mitesh_parmar]

Test.zip (8.3 KB)

Hi Please check this.

[aliaga (Ali Aga Mustofa)]

Hi @mitesh_parmar,

Sory for late reply. i need output like this to compare from time A more than time B

any solution for me?

Thankyou

[mitesh_parmar]

@aliaga

Convert same column into TEXT.