Mar 18, 2007

I have a sheet to calculate Time Elapsed based on StartDT & EndDt taking into consideration the actual working hours in any working day and the function exclude the weekend. I am not a guru in excel but i found this formula in this website .

=IF(AND(INT(StartDT)=INT(EndDT),NOT(ISNA(MATCH(INT(StartDT),HolidayList,0)))),0,ABS(IF(INT(StartDT)=INT(EndDT),ROUND(24*(EndDT-StartDT),2),

(24*(DayEnd-DayStart)*

(MAX(NETWORKDAYS(StartDT+1,EndDT-1,HolidayList),0)+

INT(24*(((EndDT-INT(EndDT))-

(StartDT-INT(StartDT)))+(DayEnd-DayStart))/(24*(DayEnd-DayStart))))+

MOD(ROUND(((24*(EndDT-INT(EndDT)))-24*DayStart)+

(24*DayEnd-(24*(StartDT-INT(StartDT)))),2),

ROUND((24*(DayEnd-DayStart)),2))))))

the formula works perfectly except for the fact that in our part of the world we have "Friday & Saturday" as the weekend days instead of Saturday and Sunday.

is there a way to get this formula or any similar formula to take different weekend days and do exactly what i need?

View 9 Replies
View Related