Hi Everyone,

I'm new to this forum and need some help with a formula in my worksheet.

Basically this is to calculate the total working hours between two dates. In many occasions this formula works, however there is a certain instance when it doesn't.

The formula is:

=(NETWORKDAYS([@[Date/Time Received]],[@[Date/Time Resolved]])-1)*($U$2-$T$2)+MOD([@[Date/Time Resolved]],1)-MOD([@[Date/Time Received]],1)

Like I say, 99/100 times this works but it appears that when there is only one day separating the two dates, and the time on the first date is later to that on the second date then it returns a value #########.
So for example 06/03/13 12:00 - 07/03/13 12:00 will correctly display 24 hours 1 minute. But if it were to be 06/03/13 12:00 - 07/03/13 11:59 then it wouldn't.

I was just wondering if anybody could assist me in finding a solution for this as it is essentially that I keep a log of activity.

P.S. If you are wondering what is at U2 and T2, they are the opening and closing times.

Thanks a lot.