You are viewing limited content. For full access, please sign in.

Question

Question

Forms Reporting - Duration Time

asked on October 27, 2021

Hello all,

I am trying to run a report using the 'Reports' function in Laserfiche Forms and I am using the 'Duration' field in my report. When I do so, I get a lot of "less than a minute" etc. The purpose of the report is so that we can track the duration of time an employee is in certain tasks. When we download the report to Excel, the data is in text so it's hard to calculate with "less than a minute" and "2 hours 3 minutes". Any way we can have it just display '123 minutes"?

Are the operational reports a better option? I have tried sifting around in there and I feel like I am in the right place, but can't exactly find that specific piece of information.

Thank you all in advance. 

0 0

Replies

replied on November 2, 2021

The duration column for tasks list do use friendly time with multiple units, it is same no matter you download from Tasks list or Operational report. If you want to calculate the duration to only show the minutes, you can add the completed date column to the task list and use formula in Excel directly to calculate the duration between the completed date and last assigned date.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.