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

start date & time	end date & time	what i get (minutes)	desired result (minutes)
8/10/2018 5:08:00 PM	8/13/2018 5:10:00 PM	4322	1442

<tbody>
</tbody>

Thank you in advance!

 

[nmr4u]

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