Getting just the time in Date-time cell

Question

Yannick Tabot Njami 2022-10-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1838223-getting-just-the-time-in-date-time-cell

回答： Steven Lord 2022-10-28

采纳的回答： Florian Bidaud

data.mat

Hello Please can someone help me get just the time in this date-time cell array?

I will appreciate the efforts.

attached is the data.

the first 10 rows looks like this and i want a new row with just the time such [12:33:00 12:34:00 12:35:00] and so on

'16.09.2020 12:33:00'

'16.09.2020 12:34:00'

'16.09.2020 12:35:00'

'16.09.2020 12:36:00'

'16.09.2020 12:37:00'

'16.09.2020 12:38:00'

'16.09.2020 12:39:00'

'16.09.2020 12:40:00'

'16.09.2020 12:41:00'

'16.09.2020 12:42:00'

thanks

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Florian Bidaud 2022-10-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1838223-getting-just-the-time-in-date-time-cell#answer_1086198

在 MATLAB Online 中打开

Hi

for i = 1:length(txt(:,1))
    if ~isempty()
txtSplit = strsplit(txt{i,1},' ');
txt{i,2} = txtSplit{2};
end

The value when the time is 00:00 is empty, so you will have to add the following check :

for i = 1:length(txt(:,1))
    txtSplit = strsplit(txt{i,1},' ');
    if length(txtSplit) == 1
        txt{i,2} = '00:00:00';
    else
        txt{i,2} = txtSplit{2};
    end
end

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Yannick Tabot Njami 2022-10-28

thank you very much for the help :)

请先登录，再进行评论。

Answer 2

Steven Lord 2022-10-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1838223-getting-just-the-time-in-date-time-cell#answer_1086273

在 MATLAB Online 中打开

I would turn the text representation of the dates and times into a datetime array then call the timeofday function on that array. If you need the representations as a string you can call string on the duration array created by timeofday.

s1 = {'16.09.2020 12:33:00'
'16.09.2020 12:34:00'
'16.09.2020 12:35:00'
'16.09.2020 12:36:00'
'16.09.2020 12:37:00'
'16.09.2020 12:38:00'
'16.09.2020 12:39:00'
'16.09.2020 12:40:00'
'16.09.2020 12:41:00'
'16.09.2020 12:42:00'};
dt = datetime(s1)
dt = 10×1 datetime array
   16-Sep-2020 12:33:00
   16-Sep-2020 12:34:00
   16-Sep-2020 12:35:00
   16-Sep-2020 12:36:00
   16-Sep-2020 12:37:00
   16-Sep-2020 12:38:00
   16-Sep-2020 12:39:00
   16-Sep-2020 12:40:00
   16-Sep-2020 12:41:00
   16-Sep-2020 12:42:00
du = timeofday(dt)
du = 10×1 duration array
   12:33:00
   12:34:00
   12:35:00
   12:36:00
   12:37:00
   12:38:00
   12:39:00
   12:40:00
   12:41:00
   12:42:00
s2 = string(du)
s2 = 10×1 string array
    "12:33:00"
    "12:34:00"
    "12:35:00"
    "12:36:00"
    "12:37:00"
    "12:38:00"
    "12:39:00"
    "12:40:00"
    "12:41:00"
    "12:42:00"