Thread
:
putting date and time together in 1 cell
View Single Post
#
3
Don Guillett
Posts: n/a
try
=text(now(),"dd/mm/yy hh:mm:ss")
--
Don Guillett
SalesAid Software
"Robbie" wrote in message
...
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.
Reply With Quote