You need to sign in to do that
Don't have an account?
Tillu
Please provide formule for this simple calculation?
I need to calculate the Age Time of a Record , I have a field Assigned Time to catch the time of the assigned record.
so i have writtened Formulae Field to calculate the Age Time of a record is
Age_Time = Assigned_Time__c - Createddate
it is fine, but i should need to exclude saturday , sundays from this Age Time. means if it is 7 days then we dont include saturday , sunday (48 hours) ,
other wise it should be normal calculation. For ex, if record is created Tuesday and assigned on Thursday then there is no need of excluding saturday, sunday hours (48).
Since you can't access business hours in formulas you would have to calculate the number of sundays and saturdays + any time where there are people available to work on the record (nights). This can become quite a hairy formula, but I think this has been asked a few times, I would try and search the forums and google.
Have you considered https://appexchange.salesforce.com/listingDetail?listingId=a0N300000016ccNEAQ or similar?