The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Combining columns
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

c.dylag

United Kingdom
1 Posts

Posted - 03/04/2022 :  08:44:30 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin ver 2021

Hello,
I have 2 separate columns, 1 for date and 1 for time. How do I combine them into 1 column?

date time
201001 0100
201001 0115
201001 0130
201001 0145
201001 0200
201001 0215

ChaoC

USA
178 Posts

Posted - 03/04/2022 :  10:07:38 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi c.dylag,

You can highlight a column and right-click Properties.
At the bottom section of the dialog you will see Format and Display.
In the format section you can set it to either date or time.
In the display section you can set how your date or time is displayed.
To combine them, just add the date and time together in another column and set the column to be Date with display format to show both date and time.
See the attached image of how column A is set. Need to do a similar thing for column B.



Chao
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000