Time between days No weekends No holidays based on start time

[kraft]

I need to calculate time in between orders, in hours, minutes and seconds. This calculated time must not include weekends or holidays. I already have a holiday sheet created. Each operator has a different shift start and end time. For example user bwulf shift starts at 8am and ends at 5pm. The first entry calculated time should read 2 hours 2 minutes. I assuming network days formula needs to be used here. Can i have some assistance in creating this formula?



[TABLE="width: 551"]
<tbody>[TR]
[TD]Operator[/TD]
[TD]Start Time[/TD]
[TD]Finish Time[/TD]
[/TR]
[TR]
[TD]bwulf[/TD]
[TD]1/18/18 4:19 PM[/TD]
[TD]1/19/18 9:21 AM[/TD]
[/TR]
[TR]
[TD]bwulf[/TD]
[TD]1/18/18 4:13 PM[/TD]
[TD]1/18/18 4:13 PM[/TD]
[/TR]
[TR]
[TD]bwulf[/TD]
[TD]1/18/18 3:50 PM[/TD]
[TD]1/19/18 8:39 AM[/TD]
[/TR]
[TR]
[TD]bwulf[/TD]
[TD]1/18/18 3:40 PM[/TD]
[TD]1/18/18 3:53 PM[/TD]
[/TR]
[TR]
[TD]bwulf[/TD]
[TD]1/18/18 3:35 PM[/TD]
[TD]1/18/18 3:36 PM[/TD]
[/TR]
[TR]
[TD]bwulf[/TD]
[TD]1/18/18 3:20 PM[/TD]
[TD]1/18/18 3:35 PM[/TD]
[/TR]
[TR]
[TD]lgil[/TD]
[TD]1/18/18 3:05 PM[/TD]
[TD]1/18/18 3:07 PM[/TD]
[/TR]
[TR]
[TD]lgil[/TD]
[TD]1/18/18 2:06 PM[/TD]
[TD]1/18/18 2:06 PM[/TD]
[/TR]
[TR]
[TD]lgil[/TD]
[TD]1/18/18 1:53 PM[/TD]
[TD]1/19/18 8:26 AM[/TD]
[/TR]
[TR]
[TD]lgil[/TD]
[TD]1/18/18 1:10 PM[/TD]
[TD]1/18/18 1:17 PM[/TD]
[/TR]
[TR]
[TD]lgil[/TD]
[TD]1/18/18 12:53 PM[/TD]
[TD]1/18/18 12:57 PM[/TD]
[/TR]
[TR]
[TD]lgil[/TD]
[TD]1/18/18 12:40 PM[/TD]
[TD]1/18/18 3:40 PM[/TD]
[/TR]
[TR]
[TD]lgil[/TD]
[TD]1/18/18 12:14 PM[/TD]
[TD]1/18/18 12:16 PM[/TD]
[/TR]
[TR]
[TD]lgil[/TD]
[TD]1/18/18 12:10 PM[/TD]
[TD]1/18/18 12:10 PM[/TD]
[/TR]
[TR]
[TD]lgil[/TD]
[TD]1/18/18 11:48 AM[/TD]
[TD]1/18/18 12:01 PM[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel...no-holidays-based-start-time.html#post4993690

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).