Wednesday, 22 May 2019
  0 Replies
  3.2K Visits
0
Votes
Undo
Hello Sir,
Can someone help in correcting the below formula as this not working properly when end time is greater than start time

=(NETWORKDAYS(start date,End date)-1)*("19:30"-"10:00")+IF(NETWORKDAYS(End date,End date),MEDIAN(MOD(End date,1),"19:30"-"10:00"),"19:30")-MEDIAN(NETWORKDAYS(start date,start date)*MOD(start date,1),"19:30"-"10:00")

Deva
There are no replies made for this post yet.