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?
Time difference without weekends
-
- 5StarLounger
- Posts: 736
- Joined: 18 Mar 2010, 11:05
-
- Administrator
- Posts: 78671
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Time difference without weekends
With the start date/time in A1, and the end date/time in B1:
=B1-A1-(DATEDIF(A1,B1,"d")-NETWORKDAYS(A1,B1)+1)
=B1-A1-(DATEDIF(A1,B1,"d")-NETWORKDAYS(A1,B1)+1)
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 736
- Joined: 18 Mar 2010, 11:05
Re: Time difference without weekends
Lovely, thank you