PDA

View Full Version : Solved: FORMULA REQUIRED



Sathisc
03-24-2010, 11:28 AM
HI

FORMULA REQUIRED TO JOIN DATE AND TIME
I HAVE PLENTY OF DATA LIKE IN COLUMN A AND C

ABC3/24/2010 6:24 PM

I NEED A FORMULA TO JOIN THE DATE LIKE

ABC3/24/20103/24/2010 6:246:24 PM

THANKS IN ADVANCE

SATHISH

lucas
03-24-2010, 11:47 AM
Your question is not clear.

Can you be more specific?

What exactly is in the cell in column A and what exactly is in the cell in column C and what exactly do you want it to look like.

mdmackillop
03-24-2010, 11:47 AM
Can you post a small sample file showing data and expected result?

Sathisc
03-24-2010, 11:57 AM
Please find the attached. I need formula for column B which merges column A and Column C

mdmackillop
03-24-2010, 12:10 PM
=TEXT(A3,"dd/mm/yyyy") & " " & TEXT(C3,"h:mm AM/PM")
or maybe just
=A3+C3
formatted as required

Sathisc
03-24-2010, 12:46 PM
Thanks