• Shoshinsha81
• NEWBIE
• 10 Points
• Member since 2016

• Chatter
Feed
• 0
• 1
• 0
Likes Given
• 6
Questions
• 6
Replies
Need to create a formula checkbox to check if time of record creation is within business days  (Excluding weekends).

Business hours 8 am to 5 pm Central Time

I need to create a formula to get difference (Minutes) between between created date and the current time excluding weekends.

I would like to create a formula based on the Case Opened date and Case close date.
Schedule - Monday to Thursday 8 am to 8 pm
Schedule - Friday = 8 am to 6 pm

Want to modfiy formula field to show AM or PM. Thank

Current Value -  Formula: 2016-03-04 16:05
Desired Value - 2016-03-07 03:35 PM

CURRENT FORMULA:
IF (DATEVALUE(Date/Time Field__c) >=
DATE ( YEAR (DATEVALUE(Date/Time Field__c)),3,1)

14-
CASE( MOD(DATE ( YEAR (DATEVALUE(Date/Time Field__c)),3,1) - DATE (1900,1,7),7) ,
0,7,MOD(DATE ( YEAR (DATEVALUE(Date/Time Field__c)),3,1) - DATE (1900,1,7),7))

&&
DATEVALUE(Impact_Start_Time__c) <
DATE ( YEAR (DATEVALUE(Date/Time Field__c)),11,1)

7-
CASE( MOD(DATE ( YEAR (DATEVALUE(Date/Time Field__c)),11,1) - DATE (1900,1,7),7) ,
0,7,MOD(DATE ( YEAR (DATEVALUE(Date/Time Field__c)),11,1) - DATE (1900,1,7),7))
),
LEFT ( TEXT (Impact_Start_Time__c - 7/24 ), 16),
LEFT ( TEXT (Impact_Start_Time__c - 8/24), 16)
)
I'd like to display the distance between the "BillingAddress" and the given location above "ISTANCE( BillingAddress, GEOLOCATION(37.750,-122.203), 'mi' )  in MILES.