Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  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.