Log Work based on Date/Time difference of two custom fields
Hello!
We are attempting to automate the action of logging work on an issue when it transitions to the 'Done' status, while taking standard Business hours into consideration.
Our current automation is based on a custom field against the current date/time formatted for Business Days, but we would love to know if anyone has a solution to be able to capture the difference between two date/time fields with the difference being logged in native Time Tracking.
There are two hurdles that we are facing right now from our perspective:
1. How can we capture the day, hour, minute difference between two custom fields in the formatting required for 'Log Work', (i.e. 4d 3h 27m)
2. How do we take 'Business Days' into consideration to avoid capturing time that isn't during standard business hours?
Thank you!
