function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
SpongeBob_2009SpongeBob_2009 

Calculate Duration - Calendar Control?

Does anyone know of a way to calculate the time between DateTime 1 and DateTime 2, based on operating hours/calendar. 

 

For example, my client wants to know how long each stage of an opportunity took.  However, the duration is subject to operating hours, weekends, etc.  Each full day would be equal to 8-hours.

 

Can you load a calendar into salesforce, w/hours....or do I need to create a custom object.  Is this request even doable?

 

Thanks!