Re: Time Calculation

Tech-Archive recommends: Fix windows errors by optimizing your registry

i would suspect that the "VALUE" error comes from the value in D3 being
text. If you select the value for editing (select cell and press F2)
and then press enter, it should recognise it as a proper date and the
function should work.

Aristotle's idea is the best, i think. and to build on it try the
following:

=TEXT(D3-NOW(),"d \da\y\s, h \hour\s, m \minut\e\s an\d s \s\econ\d\s")

regards
Rob

.

Quantcast