Change Excel Value General to Time

Help Studio
, , ,
1

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
image
but i want that column x are set with value 13:10 with format time, so i could process it using robot.
image

any idea?

Thankyou

2

@aliaga

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

3

Hello @mitesh_parmar,

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

Thankyou

4

@aliaga

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

ScreenShot
ScreenShot877×852 88.9 KB

5

Hi @mitesh_parmar,

ive try it but it still doesnt work.

image
image889×397 7.58 KB

output
image

Output i want :
image

Thankyou

6

Test.zip (8.3 KB)

Hi Please check this.

7

Hi @mitesh_parmar,

Sory for late reply. i need output like this to compare from time A more than time B
image
any solution for me?

Thankyou

8

@aliaga

Convert same column into TEXT.
:innocent: