Calculating the difference between hours

M

mark

the #VALUE indicator means that Excel knows it should
evaluate to a number, but cannot, for some reason.

To have any idea as to specifically WHY not, you need to
at least post your formula.

-----Original Message-----

It's give's me this error: #VALUE!


Pls help !
SAMI
Click to expand...
--------------
 
T

Tom Ogilvy

He did - here it is:

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating the difference between hours 2
Relevant user should see only his data 0
MS Word Page Layout/Break/Margin Issues, help 0
Calculating the difference between hours 1
Help Wanted 1
Calculating the difference between hours 1
Combine two cells without losing data cell formats 3
Cumulative formula for word table 0

Top