I would like to capture three dates:
- When a new record was created (Date Added to Accelerator)
- When the status in “Approval Status” was changed to either Approved / Not Approved (Date Approval was Made)
- The difference in time between those two dates (Approval Duration)
*The format for Approval Duration should be in days and hours. Example “2 days, 3 hours” (Or something like 2 d 3 h, that format isn’t as important as it is to show the amt. of time in days and hours)
My concern is that because I’m using two different functions (Created Time and a Formula) that it’s having trouble computing the difference.
Please let me know if I need to change of of my existing formulas or what I can use for the Approval Duration column to make this formula work.