Convert real number into datetime

Help
,
1

Hi here
I have time variable in my excel spreadsheet like 16:34
When I use row().tostring to extract it into string it become 0.78333333…
In next step I use Convert.ToDateTime() get error in it

How can I create a date time variable get from excel spreadsheet?
Thanks

1 Like
2

If the row is in time format, use the expression like below -
Row().ToString("hh:mm")

3

An error occur
It written as "disallow implicit conversion from “string” to “integer”

4

It means, when you read the excel data, the time column is converting to integer.
So, please try to format the column to string in the excel sheet, before reading the excel sheet.

5

@mightsuccess

Try this:

DateTime.FromOADate(Convert.ToDouble(row(<index/column name>).toString)).toString(“hh:MM”);

Let me know if this works for you.

3 Likes
6

The format in excel is exactly time not integer
Even I have added a click movement to format it, it is useless
It seems when extract the time to UIPATH it become integer autonomously

7

An error occur
Comma, ‘)’ and a valid express continuation expected

8

What are you trying to do exactly because I don’t see this problem on my end? I hope you’re removing the <index/column name> and replacing that with your index or column name value.

9

@mightsuccess

Hi,

Please find the solution. Forum - DateTime_To_Double_To_DateTime.zip (7.9 KB)

Regards,
Suman

10

DateTime.FromOADate(Convert.ToDouble(row().toString)).toString(“hh:MM”)

I hope this makes it clearer now. Put the index value or the column name you were going to put inside the row().toString and this shall work.

1 Like
11

a
a959×308 17.6 KB

The picture shows it

12

Is “Time leav” your column name? If yes, put that inside quotes “”

Also, replace “mm:ss” to “hh:MM” if your time is in 24 hour format.

13

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