Time Between Two Dates Excluding weekends

**RjMaJay** · 11-06-2012, 07:57 AM

Hi There,

I hope someone will be able to help.

I need to calculate the time between two dates using Monday to Friday is a 24hr working day and the weekends are closed.

The return data should be days:hours:minutes

Test Data.xlsx

Any would be greatly appriciated, I can pay in Cookies and Milk :D

**TheExcelphile** · 11-06-2012, 09:13 AM

Use the formula =NETWORKDAYS(B2,C2)+(C2-B2)-INT(C2-B2) for the first entry and autofill. Change the format of the cells to custom format "dd:hh:mm".

Now where are my milk and cookies?