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 !!!

  • 4
    I did not proceed anything. I am totally screwed!!! – ram451 Oct 16 '15 at 11:01
  • But have you configured your business hours already? – Davin Casey Oct 16 '15 at 11:35
  • What object are you referring to? Are you trying to determine which BusinessHours are relevant to a certain user/account/contact? If so, it would be possible to store the name or id of the appropriate BusinessHours in a formula field. – Todd Sprinkel Oct 16 '15 at 14:26

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.

Thank You.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.