Subtract two dates and the result in hours

Hi Guys.

How can I have a field formulated to subtract two dates and only take into account working hours, and that does not consider holidays, and the result of the operation is in hours.

0 Dennis Wangerin over 3 years ago

Hi Jonathan,

Could you provide more details on the usecase?

In this thread there was a similar discussion with an example how to implement a SugarBPM process on that:

https://sugarclub.sugarcrm.com/explore/enterprise-professional/f/enterprise-professional-questions/2661/ignoring-saturdays-and-sundays

Also in SugarServe there is the ability to configure Business Centers, with hours of operations, holidays etc:

https://support.sugarcrm.com/Knowledge_Base/SugarBPM/Getting_Started_With_SugarBPM_for_Sugar_Serve/#Business_Centers

Would one of those work for your usecase?

Best regards,

Dennis
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel