The attached spreadsheet has a formula in column L that I need help with.
I am looking to find the elapsed time in hh:mm between the "start date" and the "resolved date". I need to make sure to eliminate any standard holidays and weekends and only calculate for a standard 8a-5p day. Please take a look at what I have so far. Any help would be greatly appreciated!
Using:
=IF(OR($L101="",$M101=""),"",(NETWORKDAYS($W101,$X101)-2)*($AA$2107-$AA$2106)+MAX(0,$AA$2107-MAX(TIME(HOUR($W101),MINUTE($W101),SECOND($W101)),$AA$2106))+MAX(0,MIN(TIME(HOUR($X101),MINUTE($X101),SECOND($X101)),$AA$2107)-$AA$2106))
Bookmarks