Attached is an Excel spreadsheet with Date and Time in 1st and 2nd columns, respectively. The 3rd column is how I want the data to look for plotting. How do I concatenate columns 1 and 2 to arrive at 3? When I concatenate, I get a number for the data instead of date.
Thanks,
Jim Williams
Hi Jim,
Your time is not being recognised as such because of the lack of space between numbers and meridian indicator. However, if you use this:
=A2+TIMEVALUE(LEFT(B2,(FIND("M",B2)-2))&" "&RIGHT(B2,2))
and copy it down the length of the data it will give you the required output. Remember to format the column appropriately.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Hi, This bit of code will do, I like you don't know how to do it as a function
I'll watch this space
Please Login or Register to view this content.
Regards Mick
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks