I still get the "VALUE" error message.
Could it be the format of either cell?
Tim


"aristotle" wrote:

Think this works?

=TEXT(D3-NOW(),"dd:hh:mm")

Regards,
A

"Tim Mills" wrote:

Hi

I have 28-Jul-05 15:40:11 in cell D3 and would like to calculate the
period remaining until it is reached. I tried using NOW in another cell
and subtracting them but "VALUE" is always returned.

Is there a formula to return it in DD/MM or DD/MM/SS ?

TIA
Tim