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

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

Hi @saneeth_kandukuri

What is the datatype of your column. :smiley:

cheers :smiley:

Happy learning :smiley:

3 Likes

0.0688889 is DATEVALUE of 1:32AM of Excel
https://analysistabs.com/excel-formulas/datevalue-function/

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

1 Like

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

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

Thank you @pattyricarte, It worked

1 Like

Your most welcome @saneeth_kandukuri

Happy to help here.

cheers :smiley:

Happy learning :smiley:

3 Likes

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