Get days, hours, and minutes between dates & exclude weekends (Help on Formula Logic)

[VBA learner ITG]

Hi all,

I need your guidance on how to amend this formula to exclude weekends.

I have tried amending the formula but I am stumped on how to achive what I need.

=IFERROR(INT(C2-B2)&" days "&TEXT(C2-B2,"h"" hrs ""m"" mins """),"")

Link below to the website I used for the above formula:

Get days, hours, and minutes between dates

 

[Fluff]

How about
=IFERROR(NETWORKDAYS.INTL(B2,C2)&" days "&TEXT(C2-B2,"h"" hrs ""m"" mins """),"")

 

[VBA learner ITG]

Hi Fluff,

Thank you for your time.

Before I posted this thread I tried with the formula you mentioned and I get a different desired result.

As you can see the original formula shows (0 days 1 hrs 12 min)

17/04/2020 06:43​

17/04/2020 07:56​

0 days 1 hrs 12 mins

With the revised formula the results appears as (1 days 1 hrs 12 min)

17/04/2020 06:43​

17/04/2020 07:56​

1 days 1 hrs 12 mins

This is where I am stumped when I try and amend the formula to exclude weekends.

 

[Fluff]

In that case just subtract 1 from the networkdays function.

 

[VBA learner ITG]

Thank you. Thats exactly what I needed to do.

 

[Fluff]

You're welcome & thanks for the feedback.