How to update workflows execution time(each separate workflow) in excel file?

Hi folks,

Need help in below scenario →

below attachment for reference in that I have three workflows Example_1,_2,_3.
after running first workflow “Example_1” let’s say it takes 1.00 min to finish. so on Example_2 takes 5.30 min and Example_3 takes 9.39 min.

image

I want to update this in excel in below format.
image

How to solve this ?

@Palaniyappan
@loginerror
@AshwinS2

Hi @prashantP
What is the process you have set in these workflows what activities been used

Thanks
Ashwin S

@AshwinS2

Thank you for response.

workflows having - click,type,read cell, write cell, if, element exist,etc.

Hi @prashantP
have you set the delay in your xaml

Thanks
Ashwin S

@AshwinS2

Yes. delays is also present…

Hi @prashantP

is it possible of sharing your xamls?

or Screenshots of all your xamls

Thanks
Ashwin S

Hi @AshwinS2

sorry, not possible to share xaml.

workflow snap is attached below

@AshwinS2 snap is quite small let me know if you need anything.

@prashantP Use dateTime variable before and after each work flow. Then use a timespan variable to get the differenc e between the datetime variables. Now you will have the time difference in this format eg. {00:01:05:0054681 }
Now, you can change to the required format by assinging to a string variable like this differencetime.ToString(“mm:ss”).Replace(“:”,“.”) will give you time in thgis format eg{1.05}.
Try and let me know if it helps

Thanks @Benone.Samuel.India

currently I am using similar way.

Assign-- start A = DateTime.Now.ToString(“HHmmss”) end B = DateTime.Now.ToString(“HHmmss”) c= B - A and its working fine but its still I want to know any other way.

Let me know if is there.

Thanks.