First off, is that actually a real Excel date in your worksheet, or is it
just Text right now (that is, what does the cell's format show)?

Will all your times be in the same time zone (I'm guessing that is what the
WET is)? If not, you will need to list the possible time zone abbreviations
for us.

When you say "convert", do you mean replace what you showed with what you
want **in the same cell**?

Rick


"Ed" wrote in message
...
Hi All,

Does anyone know how to convert this date: 07/12/2007 04:47:32 PM WET
to the following one : 7/12/2007 12:47

Is there any date command you know I may use?

Thanks,
Ed