Change B1 to MOD(A1,1)
--
David Biddulph

"BNT1 via OfficeKB.com" <u19326@uwe wrote in message
news:a2757beaed786@uwe...
Bob / David
One thousand apologies to you both, spent a long time trying to see why
you
were getting the result and I was not

Now realise that the original post in 2006 had the date in A1 and time in
B1.

My new data has the date and time all in A1

Could I ask that you patience holds out a little longer and amend the
formula
to reflect
(18/01/10 07:00:00) being in one cell

Yours very gratefully :-)

Brian









Bob Phillips wrote:
Are you sure, 18/01 07:)) returns 21/01/2010 for me (as you see, I do add
3
not 4)

HTH

Bob

thanks for the speedy responce

[quoted text clipped - 22 lines]
Thanks in advance
Brian Thompson

--
Message posted via http://www.officekb.com