Time between days No weekends No holidays based on start time

[kraft]

i have the below times I'm trying to calculate the time it takes to complete and order in hours minutes and seconds. I do not want to include weekends and holidays in the calculation. I already setup a holiday schedule.

Each operator has a different shift time which should go into the calculation. For example eguadalupe shift is from 8AM to 5 PM. i assuming i need to use the networkdays formula. Can i have some assistance in creating this formula to calculate the total time between?

eguadalupe

eguadalupe

lgilman

lgilman

lgilman

bwulfekuhle

bwulfekuhle

bwulfekuhle

bwulfekuhle

lgilman

lgilman

lgilman

<colgroup><col style="mso-width-source:userset;mso-width-alt:3145;width:65pt" width="86"> <col style="mso-width-source:userset;mso-width-alt:4169; width:86pt" width="114" span="2"> </colgroup><tbody>
[TD="width: 86"]OPID[/TD]
[TD="class: xl65, width: 114"]ORDREM3[/TD]
[TD="class: xl65, width: 114"]ORDREM4[/TD]

[TD="class: xl65, align: right"]1/18/18 1:53 PM[/TD]
[TD="class: xl65, align: right"]1/19/18 8:26 AM[/TD]

[TD="class: xl65, align: right"]1/18/18 1:10 PM[/TD]
[TD="class: xl65, align: right"]1/18/18 1:17 PM[/TD]

[TD="class: xl65, align: right"]1/18/18 12:53 PM[/TD]
[TD="class: xl65, align: right"]1/18/18 12:57 PM[/TD]

[TD="class: xl65, align: right"]1/18/18 12:40 PM[/TD]
[TD="class: xl65, align: right"]1/18/18 3:40 PM[/TD]

[TD="class: xl65, align: right"]1/18/18 12:14 PM[/TD]
[TD="class: xl65, align: right"]1/18/18 12:16 PM[/TD]

[TD="class: xl65, align: right"]1/18/18 12:10 PM[/TD]
[TD="class: xl65, align: right"]1/18/18 12:10 PM[/TD]

[TD="class: xl65, align: right"]1/18/18 11:48 AM[/TD]
[TD="class: xl65, align: right"]1/18/18 12:01 PM[/TD]

[TD="class: xl65, align: right"]1/18/18 11:31 AM[/TD]
[TD="class: xl65, align: right"]1/18/18 11:32 AM[/TD]

[TD="class: xl65, align: right"]1/18/18 11:30 AM[/TD]
[TD="class: xl65, align: right"]1/18/18 11:31 AM[/TD]

[TD="class: xl65, align: right"]1/18/18 11:29 AM[/TD]
[TD="class: xl65, align: right"]1/18/18 11:29 AM[/TD]

[TD="class: xl65, align: right"]1/18/18 11:22 AM[/TD]
[TD="class: xl65, align: right"]1/18/18 11:22 AM[/TD]

[TD="class: xl65, align: right"]1/18/18 11:17 AM[/TD]
[TD="class: xl65, align: right"]1/18/18 11:18 AM[/TD]

</tbody>

[TABLE="width: 330"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]

 

[stevieinselby]

Are all OPIDs on the same shift pattern?

If we assuming a shift pattern 08:00 to 17:00, then how would you want it to display
2018-01-22 16:00 to 2018-01-24 14:30
Would that count as 16 hours and 30 minutes?

 

[kraft]

Are all OPIDs on the same shift pattern?

If we assuming a shift pattern 08:00 to 17:00, then how would you want it to display
2018-01-22 16:00 to 2018-01-24 14:30
Would that count as 16 hours and 30 minutes?

Im not following. I just would like to know the time between to time periods based on a shift pattern.

 

[kraft]

Bump