convert time to text

[Penny Gabronino]

I have the following data in a separate column:

1) Date - 01/08/2012

2) Time - 9:17:56 AM


I need this two data to be combined in a single text in a separate column which will be resulting --- 01/08/2012 09:17


What formula could I use to convert this two data into "01/08/2012 09:17"?

 

[Hui]

Penny


Firstly, Welcome to the Chandoo.org forums.


Assuming the dates/times are in A1 & A2


a simple =A1+a2 will do the job

You may need to apply a Custom Number format of dd/mm/yyyy hh:mm

 

[mercatog]

Hi Penny

If you have date in A1 and Time in A2, try this formula

=TEXT(A1+A2,"dd/mm/yyyy hh:mm")

Regards.


Edit. Sorry didn't see you answer Sir Hui.


PS. Please, how can I delete my answer

 

[Faseeh]

Hi mercatog!


A little addition to your formula! Add AM/PM in the end:


`=TEXT(A1+A2,"dd/mm/yyyy hh:mm AM/PM")


Regards,