topic RE: Work Queues - Total Work Case Time in Product Forum

Work Queues - Total Work Case Time

AnastasiosKrap1 — Tue, 08 Sep 2020 14:56:00 GMT

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

RE: Work Queues - Total Work Case Time

John__Carter — Tue, 08 Sep 2020 16:39:00 GMT

I think the 114 is days

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

RE: Work Queues - Total Work Case Time

EVIPUTI — Tue, 08 Sep 2020 17:02:00 GMT

Hi ,

Its DTIME format -->

DTIME DD HH:MM:SS.ss 00 04:31:17.01

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

RE: Work Queues - Total Work Case Time

NileshJadhavBP — Wed, 09 Sep 2020 15:40:00 GMT

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