Apex Code Development You need to sign in to do that
Don't have an account?
sfdc-L need formula for the below scenario
Hi Team,
i have 2 custom fileds i.e startdate and enddate and data type is date/time .so i need a formula as mentioned below scenario
formula is startdate+enddate*8
ex:startdate is friday 9 am and endate is monday 5 pm so if i calculate as per above formula getting 32 hours
but my requirement ,it should not caculate satarday and sunday so the result will be 16 hours
Pls let me know asap.
Thanks!
Rather than retype it... just check this site for the answer:
http://stackoverflow.com/questions/11126378/salesforce-formula-calculate-business-hours-between-two-dates
You need to mention your working hours .else how we should understand what timing have you counted ?
Did you mean : 1. (startdate + (enddate*8))
or 2.(startdate+enddate)*8
Make your requirements clear .Only thing you want is to eliminate Saturday and Sunday fom calculation .is it ??
yes,i want to omit saturday and sunday and pls provide with examaple?
Thanks!