Hi,
I have gone through the forum rule and posting this thread again as the answer provided in the other thread is not giving me the desired result.
I have two date and business hour is from evening 5 PM till Morning 5:30 AM. I have used the below formula and it is giving me 11:30 hours whereas the hour should be 0 as these 2 dates fall on a Sunday.
Start date is 5/31/2015 9:10:00 AM and End date is 5/31/2015 11:54:00 AM.
=(NETWORKDAYS(G13,D13)-1)*($O$1-$N$1)+IF(NETWORKDAYS(D13,D13),MEDIAN(MOD(D13,1),$O$1,$N$1),$O$1)-MEDIAN(NETWORKDAYS(G13,G13)*MOD(G13,1),$O$1,$N$1)
The second result provided is 0 hours again which is wrong as the start date is 5/29/2015 9:20:00 PM and end date is 5/29/2015 10:10:00 PM.
Bookmarks