Skip to main content
Question

Time Calculation

  • October 23, 2023
  • 0 replies
  • 238 views
Forum|alt.badge.img+5

Hi, 

I am developing an app for project management.

It has a table called Projects and each projects goes throughout different stages in wich some tasks are asigned to different people. 

Our PMs needs to see the days spend in each stage in order to see which stage is the more time consuming. So, I need to count how many days it has been in that stage and when it change the stage to keep that information.

We see the process through a KanBan report, I will like this "Days in stage" field to be seen in the kanban card.

How can I do this? 

Thanks!



------------------------------
Francisco Ojeda
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+11
    1. I would have a Status field with values Not Started,In Progress, Completed . Be default all tasks will have status of Not Started , when user changes the above to In Progress , I can capture timestamp via pipeline/actions in a field DateTime called StartDateTime
    2. When the user "completes" the task, I can again capture the timestamp when the task was completed in a DateTimeField FinishedDateTime
    3. A Duration field can then calculation the duration between StartdateTime and FinishedDateTime



    ------------------------------
    Prashant Maheshwari
    ------------------------------
    Terms & ConditionsAccessibility statement