Merge date

[diltech]

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

[Ardus Petus]

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

HTH
--
AP

"diltech" <[email protected]> a écrit
dans le message de news:
[email protected]...
>
> 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
>