Time Calculation

Tech-Archive recommends: Speed Up your PC by fixing your registry

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
.

Quantcast