Note: You must be registered in order to post a reply. To register, click here. Registration is FREE!
T O P I C R E V I E W
c.dylag
Posted - 03/04/2022 : 08:44:30 AM 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
1 L A T E S T R E P L I E S (Newest First)
ChaoC
Posted - 03/04/2022 : 10:07:38 AM 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.