Work Queues - Total Work Case Time

[AnastasiosKrap1]

Hi Team,

currently we observed something strange with the 'Total Case Duration' in the Work Queues sections. Specifically, the case duration looked like this :

Can you please let me know how can we translate this ? The representation the duration is confusing. I understand that the duration pattern is the following : hh:mm:ss.sss

But how do you translate the 114.07:47:46.000 ?

Thank you

------------------------------
Tasos
Europe/London
------------------------------

[John__Carter]

I think the 114 is days

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

[EVIPUTI]

Hi ,

Its DTIME format -->

DTIME

DD HH:MM:SS.ss

00 04:31:17.01

------------------------------
[Vipul] [Tiwari] [Senior Process Simplification and Optimization Developer]
[Fidelity]
------------------------------

[NileshJadhavBP]

Hi Anastasios,

This is just suggestion from my end to resolve this.

When you are extract report data from work queue and Blue prism fetching and storing same data in excel.Please do below mention point

1.use replace function to remove last character '.000' ( as per above screenshot this is pattern)
2.Use len function to get count of entire duration length.
3.use instr to find '.' 
4.use left function to get text to remove.
5.now use replace to remove first left number.

use calculation stage to perform the above activity.

after using above points you will get clean time.

Thanks
Nilesh 



------------------------------
Nilesh Jadhav
Senior RPA Specialist
ADP
Pune
------------------------------