Substraction of Execution time

Hi Mates,
Can anyone please suggestion me the activity or sequence where i need to substract my execution start time - execution end time…
please let me know if anyone have a solution for this requirement

Praveen Kumar M

Hi @praveenchintu374,

If your start/end times are DateTime variables:

TotalTime = FinishTime.Subtract(StartTime)

If your start/end times are String variables:

TotalTime = CDate(FinishTime) - CDate(StartTime)

In both instances, TotalTime is a TimeSpan variable.

1 Like


If you are using Queues then the below expression would helpful to get the Total execution time in seconds

Var of type String Execution Time = (DateTime.ParseExact(Now.ToString, "MM/dd/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture)-DateTime.ParseExact(in_TransactionItem.StartTransactionTime.ToString, "MM/dd/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture)).TotalSeconds.ToString()

in_TransactionItem is the output of Get Transaction Item activity. When the current Transaction Item status updates to something(Success, failure etc) that time can be considered as end of Transaction Item - Start time will give you the total time of that Transaction

1 Like

Thanks @ushu

Thanks @william.coulson

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