try
=text(now(),"dd/mm/yy hh:mm:ss")

--
Don Guillett
SalesAid Software
donaldb@281.com
"Robbie" <anonymous@discussions.microsoft.com> wrote in message
news:106601c518ee$28bbb340$a401280a@phx.gbl...
> Hi I need to convert New Zealand time to UK time, the time
> is displayed in two parts
> A B
> date time
> dd/mm/yy hh:mm:ss
>
> How do i get cell A and cell B into one cell with the
> format dd/mm/yy hh:mm:ss and then I can just minus 13
> hours.
>
> any ideas please.
>
>