Issue in reading "Time" values from excel using preserve format of Read range activity (without excel application scope)

[garimavarshney9 (NA)]

Please help.
I am not able to read the time values using Read range activity (one without using excel application scope).
The values in my excel are with “Time” format.

The output I am getting looks like this in my datatable in uipath

timw.xlsx (8.2 KB)

[Srini84 (Srinivas Kadamati)]

@garimavarshney9

Check below post for your reference
Tutorial : How to Calculate difference between two Time Values using UiPath - #2 by system

Hope this helps you

Thanks

[garimavarshney9 (NA)]

Thanks… It helped.

Choosing time format from “Custom” in excel worked as shown in the video.

[Srini84 (Srinivas Kadamati)]

@garimavarshney9

Great!!

Mark as solution if this helps

Thanks