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?

OPID	ORDREM3	ORDREM4
eguadalupe	1/18/18 1:53 PM	1/19/18 8:26 AM
eguadalupe	1/18/18 1:10 PM	1/18/18 1:17 PM
lgilman	1/18/18 12:53 PM	1/18/18 12:57 PM
lgilman	1/18/18 12:40 PM	1/18/18 3:40 PM
lgilman	1/18/18 12:14 PM	1/18/18 12:16 PM
bwulfekuhle	1/18/18 12:10 PM	1/18/18 12:10 PM
bwulfekuhle	1/18/18 11:48 AM	1/18/18 12:01 PM
bwulfekuhle	1/18/18 11:31 AM	1/18/18 11:32 AM
bwulfekuhle	1/18/18 11:30 AM	1/18/18 11:31 AM
lgilman	1/18/18 11:29 AM	1/18/18 11:29 AM
lgilman	1/18/18 11:22 AM	1/18/18 11:22 AM
lgilman	1/18/18 11:17 AM	1/18/18 11:18 AM

<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>
</tbody>

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>

 

[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