Calculation of duration (in days or hours) from start date and date when ticket was closed

Added by Shariqh Shaikh 2 months ago

Hi!

I am looking for a way by which i could calculate duration between start date and date on which the ticket was closed.
Eg. Start date - 03/08/2020 and ticket was closed on 10/08/2020 (dd/mm/yyyy format). There should be duration field in issue report which will give difference as 5 days (Saturday and Sunday is set as holiday from admin setting). Already using redmine_closed_date plugin to get closed date. Please help me out to achieve it.

Thanks for your help.

Environment:
Redmine version 4.1.1.stable
Ruby version 2.5.8-p224 (2020-03-31) [x64-mingw32]
Rails version 5.2.4.2
Environment production
Database adapter Mysql2
Mailer queue ActiveJob::QueueAdapters::AsyncAdapter
Mailer delivery smtp
OS - windows.