need to merge date and time in 5 separate columns in to two and then one

I have date and time in 5 columns like

YYYY

MM

DD

HH

mm

I wanted to get two colums as date and time

YYYYMMDD and

HHmm

Then a third column like

YYYYMMDDHHmm

Can you please guid im beginner, Thank you verry mutch

Answer 1

[Walter Roberson]

dt = datetime(YourTable.YYYY, YourTable.MM, YourTable.DD, YourTable.HH, YourTable.mm, 0);

newTable.YYYYMMDD = dt; newTable.YYYYMMDD.Format = 'uuuuMMdd';
newTable.HHmm = dt; newTable.HHmm.Format = 'HH:mm';
newtable.YYYYMMDDHHmm = dt; newtable.YYYYMMDDHHmm.Format = 'uuuuMMddHHmm';

This assumes that you would be okay with the table containing the same data for the three columns as long as what is displayed is in the format you indicated. If the entries have to contain only the data you indicate then the process would be different. Would the entries have to be numeric? Such as 202209121536 ?

[Amila]

Thank you very mutch with my data sheet i have used this with some modifications cord I used is

dt2 = datetime(Result2(:,1), Result2(:,2), Result2(:,3), Result2(:,4), Result2(:,5), 0);

Thank you verry much !

[Eric Sofen]

Depending on what you want to do with the HHmm data, you may want to use the timeofday function on the datetime to get a duration in hours and minutes from midnight of the current day, rather than just changing the format.

newTable.HHmmdur = timeofday(dt)