Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Can i create a formula field to calculate the time in business hours between Case created date to now/Closed date? I'm looking for a non code solution which is equivalent to finding the difference in date/time using apex with the BusinessHours.diff() method.

share|improve this question
up vote 6 down vote accepted

I'm pretty sure this can't be done without code. There is no formula that accesses the business hours settings. Sorry!

share|improve this answer

You could try this answer which calculates the time difference but you would have to make assumptions about the business hours and the formula wouldn't mirror exactly to them. Hopefully close enough

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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