Hi Guru's.

My lovely spread sheet has been working nice for the past couple of weeks and is now playing funny buggers.

I have a formula calculating a countdown timer
(Cell I6) =IF(VALUE(G6)<H6,”Breached”,VALUE(G6-H6)) (displayed as Breached or 1:24:26)
(Cell G6) is the Due Date (displayed as 28/02/2012 15:13)
(CellH6) is Todays date (displayed as 28/02/2012 15:13)
Now what has started to happen randomly is that when the countdown gets to 0:00:00 Rather than displaying Breached it is adding 24:00:00
Or we have a due date of 10/08/2012 15:52
Todays date as 09/08/2012 15:19
And the calculation is showing 0:33:29

What is going wrong… It is really doing my head in.

So I have somewhat found why it is playing up in that it is only calculating the hours until the time counts down (not taking the date into account as it was formatted as time)

I tried Formatting the Cell to be Custom [H]:mm:ss - Which then gives me the cumulative... But I cant figure out where to work "Workdays" into the formula. And also making this change has also broken my conditional formatting.

I have attached the spread sheet for anyone who can help me figure this out.