I need to store the organization business hours value in a field .. Is it possible to store that in a formula field ? If not , by any chance can we get the organization business hours through coding or something ? In my org , there are 33 countries and each country has different org business hours(monday - sunday)... Please help me out !! thanks in advance !!!
You can get organization business hours using Apex code. Salesforce has object named "BusinessHours" which has details of business hours from Monday-Sunday.
You can write your logic around this object and show desired results.
Object Reference: BusinessHours
If you are looking for a functionality to later find out difference between date fields which provide the business hours. You can create formula field to calculate that.
In the Common Date Formulas following section might be helpful for you.
- Finding the Number of Business Hours Between Two Date/Times
You can tweak the formula little bit as per the need.