Calculating the difference between hours
 

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


--
Sambusa
------------------------------------------------------------------------
Sambusa's Profile: http://www.excelforum.com/member.php...o&userid=14960
View this thread: http://www.excelforum.com/showthread...hreadid=265883

Calculating the difference between hours
 

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:

--
Regards,
Tom Ogilvy


"Sambusa" wrote in message
...

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


--
Sambusa
------------------------------------------------------------------------
Sambusa's Profile:
http://www.excelforum.com/member.php...o&userid=14960
View this thread: http://www.excelforum.com/showthread...hreadid=265883