I am currently using the following formula to calculate work hours. However
when I do not have an end date / time it very large number is calculated

In the example below the start date is 2008/08/11 11:17 with no end date and
the calculation is 711311.22

How can I change the foluma to have a zero if no end date is completed?

IF(OR(O105<1,AND(INT(V105)=INT(O105),NOT(ISNA(MATC H(INT(V105),List!A$9:A$24,0))))),0,ABS(IF(INT(V105 )=INT(O105),ROUND(24*(O105-V105),2),
(24*(X105-W105)*
(MAX(NETWORKDAYS(V105+1,O105-1,List!A$9:A$24),0)+
INT(24*(((O105-INT(O105))-
(A105-INT(V105)))+(X105-W105))/(24*(X105-W105))))+
MOD(ROUND(((24*(O105-INT(O105)))-24*W105)+
(24*X105-(24*(V105-INT(V105)))),2),
ROUND((24*(X105-W105)),2))))))


--
Andrew