Networkdays calculate hours between date and time.

[Weeble]

Trying to solve a time issue.

[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]Arrival time[/TD]
[TD]Unload date[/TD]
[TD]Unload complete[/TD]
[TD]Completed[/TD]
[TD]Total time[/TD]
[/TR]
[TR]
[TD]11:30[/TD]
[TD]02-okt[/TD]
[TD]02-okt[/TD]
[TD]12:30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10:30[/TD]
[TD]02-okt[/TD]
[TD]03-okt[/TD]
[TD]9:30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13:00[/TD]
[TD]06-okt[/TD]
[TD]09-okt[/TD]
[TD]8:00[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I want to be able to get how many hours from Arrival to completed my order has taken.
I am assuming I need to work with =networkdays

=NETWORKDAYS(B2;C2;WEEKEND!A3:A28)

Which returns 24 hours. But how do I take the time in account here aswell? I want a formula in E2 that returns 1hour, E3 should return 23 hours, and E4 should return 19 hours (6-okt being a friday).

Would it be easier if I merged B + A and C + D together? or is it possible to do without it?

 

[CalcSux78]

Try:

=NETWORKDAYS(B2;C2;WEEKEND!A3:A28)-1+(D2-A2)


Note:

Set Number Format for Column E to: [h]:mm

 

[Weeble]

I tried it out and it only works on the days where unload date and unload complete is the same date. If completion date is > than unload date, the cell just turns ##############.