Extraction of Excel Data of column Splitter Type "1:32"

Help
1

Hi , while extracting the data of value from excel of column “Splitter Type” of cell value “1:32” , i was getting output as 0.0688889 , this is wrong output …can anyone pls help to get output as “1:32”.
image

I need output as 1:32…

1 Like
2

Hi @saneeth_kandukuri

What is the datatype of your column. :smiley:

cheers :smiley:

Happy learning :smiley:

3 Likes
3

0.0688889 is DATEVALUE of 1:32AM of Excel

correct cell format of your Excel sheet ( correct general to string)

1 Like
4

Hi @pattyricarte

 Datatype for this column is default type. How can I get the value in the cell exactly like "1:32". Please suggest me.
1 Like
5

Have you try to change the dafault to text in excel and try it to uipath what is the output value.
Just a trial and error only.

cheers :smiley:

Happy learning :smiley:

4 Likes
6

Thank you @pattyricarte, It worked

1 Like
7

Your most welcome @saneeth_kandukuri

Happy to help here.

cheers :smiley:

Happy learning :smiley:

3 Likes
8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.