Missing lunch!!!

[robert_woodie]

I am using this formula fro
http://www.cpearson.com/excel/DateTimeWS.htm

=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))))

It works great but it assumes they work through lunch. I have trie
unsuccessfully to modify the formula (mainly because i dont understan
it!!)
Lunch runs from 12:00 untill 12:45 (45 mins)

Thanks in advance
Rober

 

[DNF Karran]

I *think* subtracting lunch wherever you see DayEnd-DayStart would do.

ie- add a new range called "Lunch" with a value of 00:45 and chang
every "dayend-daystart" to "dayend-daystart-lunch"