Time difference without weekends

Egg 'n' Bacon
5StarLounger
Posts: 736
Joined: 18 Mar 2010, 11:05

Time difference without weekends

Post by Egg 'n' Bacon »

We are trying to come up with a formula that will result in hh:mm (result cells are formatted as [h]:mm) between two date/times, that does not include weekends.

For example;
4th July 2016 10:00
minus
29th June 2016 16:30
results in 113:30 not 65:30

Any ideas?

User avatar
HansV
Administrator
Posts: 78671
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Time difference without weekends

Post by HansV »

With the start date/time in A1, and the end date/time in B1:

=B1-A1-(DATEDIF(A1,B1,"d")-NETWORKDAYS(A1,B1)+1)
Best wishes,
Hans

Egg 'n' Bacon
5StarLounger
Posts: 736
Joined: 18 Mar 2010, 11:05

Re: Time difference without weekends

Post by Egg 'n' Bacon »

Lovely, thank you