Change data type column in excel

#1

Hello guys,
I’m just a beginner in uipath and I’m so glad I found this place. I’ve learned so much from other questions here, but there’s something I just can’t figure out how to do.

So, I could really use your help in this.

I’m using uipath to subtract two columns in an excel workbook with time values.
Let’s call the first column “last_updated_time” and the second “assignment_time”
When I subtract these two columns I get the time passed for a certain activity to be completed.
The problem is that the outcome is in the form of “0,2543” when I need it to be in “HH:mm:ss”.

How can I change the data type with uipath instead of doing it manually in excel???

Can anyone please help me out here?

Thank you in advance!

#2

Hey @1webplace

I found this from another site…

If you can get the datediff of the two days in seconds using the below function, the you can add it to the next logic below to convert it to your format…

DateDiff

Date and time.DateDiff(“s”, date1, date2)

Convert seconds to date format

    DateTime date = new DateTime(1970,1,1,0,0,0,0); //Set default date 1/1/1970
    date = date.AddSeconds(1365004800); //add seconds
    label1.Text = date.ToString(); //Display result 2013-04-03 16:00:00

Hope this helps

1 Like
#3

Hi!
Thank you so much for your immediate response!
Unfortunately, I have no idea where to place that.
If you could guide me through it, I’d appreciate it so much…

#4

Hi again,

I’ve managed to get the time format value from the topic below:

But the outcome time comes in a message box. Does anyone know how can I write it in a column is excel?

Please, help…

#5

Can anyone help me with this please???

#6

I managed to do it on my own, so the topic can now close.

#7

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