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???
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
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…