topic Re: Calculate job time in workforce in ArcGIS Workforce Questions

Calculate job time in workforce

ThomasKelly — Mon, 01 Jun 2020 17:08:33 GMT

Is there a way to calculate the time between a job being assigned and completed in workforce? I cannot seem to find any examples or resources any pointers would be useful.

Many thanks

Re: Calculate job time in workforce

CraigGillgrass — Mon, 01 Jun 2020 17:17:15 GMT

Hi Thomas,

This doc topic has some information on how to do this:

Automate and script Workforce—Workforce for ArcGIS | Documentation

Craig

Re: Calculate job time in workforce

ThomasKelly — Mon, 01 Jun 2020 17:26:22 GMT

Thanks Craig, I will make my way there. Much appreciated!

Re: Calculate job time in workforce

ThomasKelly — Tue, 02 Jun 2020 11:42:51 GMT

Hi Craig,

I have gone through this but there is no mention of calculating the total time spent on an assignment. I have tried adding a field to my assignments layer and calculated from there but this does not return the correct figure.

Have you any other links that may help?

Many thanks

Thomas

Re: Calculate job time in workforce

CraigGillgrass — Tue, 02 Jun 2020 11:56:53 GMT

Thomas,

The doc doesn't have an outlined example of how to calculate the total time spent on an assignment, but the section titled Assignment status date and time fields does document the various date/time fields for each status.

You'd want to subtract the assignedDate from the completedDate.

The rest of the section explains how the date/time fields work.

Let me know if that helps.

Craig