Merge date
 

I want to merge date from two cells in this format 2006-09-15 13:00:50

A1 = 2006-09-15 and B1 = 13:00:05


How can do that ?

Thanks


--
diltech
------------------------------------------------------------------------
diltech's Profile: http://www.excelforum.com/member.php...o&userid=35716
View this thread: http://www.excelforum.com/showthread...hreadid=554984

Merge date
 

=A1+B1
custom format as yyyy-mm-dd hh:mm:ss

HTH
--
AP

"diltech" a écrit
dans le message de news:
...

I want to merge date from two cells in this format 2006-09-15 13:00:50

A1 = 2006-09-15 and B1 = 13:00:05


How can do that ?

Thanks


--
diltech
------------------------------------------------------------------------
diltech's Profile:
http://www.excelforum.com/member.php...o&userid=35716
View this thread: http://www.excelforum.com/showthread...hreadid=554984