Deducting date & time

T

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
 
F

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
 
P

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)
 
F

Frank Kabel

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

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?
 
Top