Skip to main content
hamburger menu Created with Sketch.
Veeva Support APAC Holiday Sep 15th - Sept 17th- Limited staff, please plan accordingly

Search the Knowledge Base

How to Exclude Weekends from the Task Duration Field in Vault Workflow Reports?

  • Updated

Question:

Task Duration is the amount of time between task creation and task completion. Vault calculates this number by dividing the number of minutes between task creation and task completion by the number of minutes in a day.

The task duration does not take into account weekends. Is there a way to exclude weekends?

Answer:

The best workaround is to export the report to Excel Template that includes the networkdays() function.

  1. Navigate to the Report tab and create a report of Workflow with Documents report type.
  2. In the report, add Task Creation Date, Task Completion Date, and Task Duration columns.
  3. Expand the Advanced Options section and click Sample to download the file.

    mceclip2.png

  4. In the downloaded sample Excel Template, set Task Duration as =NETWORKDAYS(G5,H5), which returns the number of whole working days between Task Creation Date and Task Completion Date.

    mceclip1.png

  5. Go back to the report and upload the updated Excel Template by clicking the Upload button.

    mceclip3.png

  6. Once uploaded, save and run the report.
  7. Export the report to the Excel Template by clicking the Action Menu --> Export to Excel Template.

    mceclip4.png

  8. In the exported report, the Task Duration is calculated by excluding the weekends.

    mceclip5.png

Related Documentation:

Vault Help Documentation: Using Excel Report Templates

Powered by Zendesk