Hour/Minute difference between two dates (networkdays)

[ellyzadg]

Hi All,

Good day! How can I get the hours or minute difference between two date but those dates should only count network days

Fri - 10
sat - 11
sun- 12
mon - 13

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]start date & time[/TD]
[TD]end date & time[/TD]
[TD]what i get (minutes)[/TD]
[TD]desired result (minutes)[/TD]
[/TR]
[TR]
[TD]8/10/2018 5:08:00 PM[/TD]
[TD]8/13/2018 5:10:00 PM[/TD]
[TD]4322[/TD]
[TD]1442[/TD]
[/TR]
</tbody>[/TABLE]


Thank you in advance!

 

[nmr4u]

say a1 contains start and b1 contains end.
=((B1-A1)*1440)-(NETWORKDAYS(A1,B1)*24*60)