Help required for NETWORKDAYS

[mrinal saha]

Hi, Am using the below formula to get the actual hours between two dates excluding weekend (Fri-Sat). However, it seems am getting it not right. Any help will be be appreciated. Thanks

=(NETWORKDAYS.INTL(A3,B3,7)-1)*("7:30"-"16:00")+IF(NETWORKDAYS.INTL(B3,B3,7),MEDIAN(MOD(B3,1),"7:30"-"16:00"),"16:00")-MEDIAN(NETWORKDAYS.INTL(A3,A3,7)*MOD(A3,1),"7:30"-"16:00")

 

[Taul]

Hi,
Try swapping the working hours around. Change ("7:30"-"16:00") to ("16:00"-"7:30")

=(NETWORKDAYS.INTL(A3,B3,7)-1)*("16:00"-"7:30")+IF(NETWORKDAYS.INTL(B3,B3,7),MEDIAN(MOD(B3,1),"16:00","7:30"),"16:00")-MEDIAN(NETWORKDAYS.INTL(A3,A3,7)*MOD(A3,1),"16:00","7:30")