+ Start a Discussion
sfdc-Lsfdc-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!

phiberoptikphiberoptik
sourav046sourav046

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

sfdc-Lsfdc-L

yes,i want to omit saturday and sunday and pls provide with examaple?

 

Thanks!