Inserting Yesturday's date before Numric data

[TUSHAR_0712]

I have column which contain hours date (like 12:45), I want to put yesterday's date before that hour.
my col looks like this
12:45
13:40
14:55
17:40

it should be like this, considering today's date is 11/20/2013
11/19/2013 12:45
11/19/2013 13:40
11/19/2013 14:55
11/19/2013 17:40

I tried with concatenate with today()-1 but its not working. I want a formula which I can use for whole col as there is more than 5000 row in it.

Thanx in advance...

[M1234]

Try this:

=TEXT(TODAY()-1,"mm/dd/yy")&" "&TEXT(A1,"hh:mm")

If your time is in A1, it should pull it out as you wanted.

[ragulduy]

I think today()-1 will give you a number, maybe try:
=concatenate(A1,text(today()-1,"DD/MM/YYYY"))
or
=A1 & TEXT(TODAY()-1,"DD/MM/YYYY")

[Ghozi Alkatiri]

=TEXT(TODAY()-1+A1,"mm/dd/yyy hh:mm")

[TUSHAR_0712]

Awesome !!!!
Thanx M1234, It worked.

[TUSHAR_0712]

Hello Ghozi,

Its returning numeric value, neways thanx lot for your time on my prob :-)

[TUSHAR_0712]

Yudlugar,

ys its returning numeric, thanx for ur effort n time. M1234 suggestion workd for me.