1) I have an Excel which has Start Time & End Time against Part Number. So, for these cases I have to calculateTime Interval on the basis of their defined Window. For some Part Numbers, it will work from Mon-sat or Mon-Fri or All 7 Days as per the defined window.
Also, need to exclude Holidays.
2) Those cases, which are not in excelcalculate their Time Interval on the basis of Flags:
If Flag is CDE than consider Mon-Sat - 9:30 - 18:00
If Flag is AB than consider Mon-Fri - 9:00 - 17:30
Re: Calculate Time Interval on the Basis of Logic b/w 2 Timestamps
I don't find date in your input data. Your desired output excel sheet is not linked to windowmain sheet too. Only the logic(based on flag) of sat/sun exclusion is clear to me. Try to logically link the sheets and explain, and may be a clue on how you get the date could help a bit.