Working day(s)/Time between two dats (No Weekend or Holidays)
 

I am trying to calculate the number of working day(s) / Working
Hour(s) / Min(s) to get a task done...

I have been using the below formulas to get my results, but, I need my
output to be based on a working hours not a 24 hour day (Also, no
weekends and holiday)…

I have not entered the Holiday into the NetworkDay formula shown
below...

Day(s)
=ROUNDDOWN(NETWORKDAYS(D2,IF(ISBLANK(E2),NOW(),E2) )
+MOD(IF(ISBLANK(E2),NOW(),E2),1)-
MOD(D2,1)-1+IF(WEEKDAY(D2,3)4,MOD(D2,1),
0)+IF(WEEKDAY(IF(ISBLANK(E2),NOW(),E2),3)4,1-
MOD(IF(ISBLANK(E2),NOW(),E2),1),0),0)

Hour(s)
=ROUNDDOWN((NETWORKDAYS(D2,IF(ISBLANK(E2),NOW(),E2 ))
+MOD(IF(ISBLANK(E2),NOW(),E2),1)-
MOD(D2,1)-1+IF(WEEKDAY(D2,3)4,MOD(D2,1),
0)+IF(WEEKDAY(IF(ISBLANK(E2),NOW(),E2),3)4,1-
MOD(IF(ISBLANK(E2),NOW(),E2),1),0)-G2)*24,0)

Min(s)
=(((NETWORKDAYS(D2,IF(ISBLANK(E2),NOW(),E2))
+MOD(IF(ISBLANK(E2),NOW(),E2),1)-
MOD(D2,1)-1+IF(WEEKDAY(D2,3)4,MOD(D2,1),
0)+IF(WEEKDAY(IF(ISBLANK(E2),NOW(),E2),3)4,1-
MOD(IF(ISBLANK(E2),NOW(),E2),1),0)-G2)*24)-H2)*60

project Submitted Data Finish Date Days Hours
Min
Generation Thu 4/24/08 10:19 PM Tue 4/29/08 4:11 PM 2 17 52
Review Tue 4/29/08 4:11 PM Wed 4/30/08 1:31 PM 0 21 20
Pre Check Wed 4/30/08 1:31 PM Wed 5/7/08 10:56 AM 4 21 25
Route Wed 5/7/08 10:56 AM Wed 5/7/08 1:06 PM 0 2 10
CCB Wed 5/7/08 1:06 PM Tue 5/13/08 6:00 AM 3 16 55
CCB to MRP Tue 5/13/08 6:00 AM Tue 5/13/08 9:36 AM 0 3 36
MRP to Incorp Tue 5/13/08 9:36 AM 2 3 41
Total Elapsed Time: 14 14 59