Space in between date and time stamp

[Halmsteen]

Hi, I have tried to get the date and time stamp from another tab but it does not space out in between.
How should I do it? My cell reads 5/8/2012 9:20:29 PM showing 5/9/2012 21:20.

My other tab in cell is =IF(ISBLANK('Raw '!S2),"",MONTH('Raw '!S2)&"/"&DAY('Raw '!S2)&"/"&YEAR('Raw '!S2)&"/"&HOUR('Raw '!S2)&":"&MINUTE('Raw '!S2)) and returns 5/9/2012/2:57.
Please help, I want only the date(m/dd/yyy) and time (hr:min) only. Prefered return value to be 5/9/2012 21:20. Thanks!

[AlphaFrog]

Try this to remove the seconds...

=IF(ISBLANK('Raw '!S2),"",TEXT('Raw '!S2, "m/d/yyyy hh:mm")*1)

Format the cell with this formula with any date-time format you like.

[BigDawg15]

Halmsteen,

Remove the / between the quotation marks before &hour and leave a space between them. Should take care of it.

BigDawg15

[Halmsteen]

Thank you AlphaFrog and BigDawg15. Both answers helps. Cheers!