Thank you so much!
This has been annoying me for so long! It was not in time at all it was text as you suspected -thanks
Might use Focus more often now!

Nicola



David Biddulph wrote:

If you have actually got the data in there as an Excel time,
23-Oct-09

If you have actually got the data in there as an Excel time, use
=MROUND(A1,1/24/3600) (and look up MROUND in Excel help if you have
problems).
If it is there as text, =LEFT(A1,LEN(A1)-2) if you want to keep it as text,
or =--LEFT(A1,LEN(A1)-2) (and format appropriately) if you want it
converting to time.
--
David Biddulph

<Nicola Blackie wrote in message

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
A Low-Overhead SysLog Message Sender Class
http://www.eggheadcafe.com/tutorials...yslog-mes.aspx