I have a large Excel spreadsheet of tasks, called "packages," completed by a group of employees. Each package is logged by a program with a time stamp of when they opened it and when they completed it. So I have a large database of packages with start and end dates and times. The average span is about 7 days. So, I'm looking for a way to determine approximately how much time was spent working on each package (unfortunately, the program doesn't track that). Using an assumed average working time of M-F 7am to 12pm, and 1pm to 3:30pm, I want Excel to calculate how many hours within those spans overlap with the time interval for each package and to also exclude Saturday and Sunday. For example, if a package was started on a Wednesday at 2:00pm and then finished the following Tuesday at 9:00am, I want Excel to tell me the assumed number of hours worked on the package. So on Wednesday (2-3:30) 1.5 hrs were worked, on Thursday (7-12 and 1-3:30) the full 7.5 hours were worked, 7.5 hours for Friday, skip Saturday and Sunday, 7.5 hours on Monday, and then for Tuesday (7-9) 2 hrs. So it should give me a total of 26 hours worked on that package. Do you think there's any way to accomplish this? Thanks.