Calculating the difference between hours

  • Thread starter Thread starter Sambusa
  • Start date Start date
S

Sambusa

Thia was what i want ( Pls can u help me again )


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

I am working with it from yesterday but still i am facing a problem,
Can u do favor for me & write one example pls pls as soon as possible


I am waiting for u

SAMI
 
You haven't asked a question. You said you are having a problem, but not
what kind of problem. You have the formula - do you not understand how to
modify it to refer to specific cells in your spread sheet. If so, it
wouldn't do anygood for someone to make up a layout and modify the formula
as that is explained on Chip's page. So perhaps you could specify the cells
you want to evaluate in terms of where the information needed by the formula
is located.

Start Date is in cell:
End Date is in cell:
Day End is located in cell:
Day Start is located in cell:
Holiday list is in cells:
 
Back
Top