Networkdays calculate hours between date and time.

[Weeble]

Trying to solve a time issue.

A	B	C	D	E
Arrival time	Unload date	Unload complete	Completed	Total time
11:30	02-okt	02-okt	12:30
10:30	02-okt	03-okt	9:30
13:00	06-okt	09-okt	8:00

<tbody>
</tbody>

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 ##############.