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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.