Deducting date & time

[Tim Mills]

Hi

I'm on XL 2000. In cell B3 I have a set date & time of
08/07/2004 16.30 , the NOW function in cell B4 and would
like to calculate the difference in days, hours & mins in
B5.

I tried formatting B5 the same as the others with the
formula =C3-B3 but the result is the dreaded #VALUE.

Is it poss to return a result - I can live with something
other than DHM.

TIA
Tim

 

[Frank abel]

Hi
try something like
=B3-NOW()
if b3 is in the future
or
=ABS(B3-NOW())

after this format the resulting cell with the custom format
d hh:mm:ss

 

[Peo Sjoblom]

abel? That's what you get for using CDO <g>

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Frank Kabel]

Hi Peo
and i §$%&&% this CDO interface. But what can you do if
the firewall does not allow newsgroups :-(

 

[Dave Peterson]

It looks like 16.30 isn't a real time.

If you put 08/07/2004 16:30 (note the colon), does your formula work ok?

 

[Tim]

Thanks Guys - they both work.
Must remember to check for . instead of :