Time stamp formatting question

4 次查看（过去 30 天）
Sergio Mendoza
Sergio Mendoza 2019-6-17
编辑： Adam Danz 2019-6-17
Hi everyone -
I have a time stamp in the following form : '0d 00:00:5.03000020980835'
I am trying to convert it into a vector in hh:mm:ss, any ideas?
  2 个评论
Walter Roberson
Walter Roberson 2019-6-17
Do you need the seconds to come out as 5.03 with no 000020980835 stored?
Adam's suggestion is not bad, but it does end up storing as 00:00:05.030000208 (I might have expected 00:00:05.030000210) . If the 0000208 is not desired, then Adam's code would need to be modified.
Question: is the number of days ever non-zero ?
Sergio Mendoza
Sergio Mendoza 2019-6-17
编辑：Sergio Mendoza 2019-6-17
The number of milliseconds is not critical, 5.03 is what I would expect. There is a caveat and that is that for some entries, there are no milliseconds recorded:
'0d 00:00:0'
'0d 00:00:1'
'0d 00:00:2'
'0d 00:00:3'
'0d 00:00:4'
'0d 00:00:5'
'0d 00:00:5.03999996185303'
'0d 00:00:6.03999996185303'
'0d 00:00:7.03999996185303'
'0d 00:00:8.03999996185303'
'0d 00:00:9.03999996185303'
Also, the number of days is not always zero

请先登录，再进行评论。

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

采纳的回答

Adam Danz
Adam Danz 2019-6-17
编辑：Adam Danz 2019-6-17
dtstr = '0d 00:00:5.03000020980835';
dtstr = regexprep(dtstr,'\d+d',''); %remove days
dt = datetime(dtstr,'InputFormat','HH:mm:ss.SSS','Format','HH:mm:ss')
[update]
To preserve the number of days within the hour-count and to account for missing decimals in the seconds,
dtstr = {'0d 23:59:58.439998626709'
'0d 23:59:59'
'1d 00:00:0'
'1d 00:00:1.44000005722046'
'1d 00:00:2.44000005722046'
'1d 00:00:3.44000005722046'};
% Add .0 to time stamps that are missing the decimal
noDecIdx = ~cellfun(@(x)contains(x,'.'),dtstr);
dtstr(noDecIdx) = cellfun(@(x)[x,'.0'],dtstr(noDecIdx),'UniformOutput',false);
% replace "d " with ":"
dtstr = strrep(dtstr,'d ',':');
% Convert to your desired format as durations
D = duration(dtstr,'InputFormat', 'dd:hh:mm:ss.S','Format','hh:mm:ss');
Result:
6×1 duration array
23:59:58
23:59:59
24:00:00
24:00:01
24:00:02
24:00:03
  7 个评论
显示 5更早的评论
Sergio Mendoza
Sergio Mendoza 2019-6-17
Yes, it works, but what I woudl like is that once the day rolls into a new one, I can still keep track of the total amount of hours ellapsed.
'0d 23:59:58.439998626709'
'0d 23:59:59.439998626709'
'1d 00:00:0.439999997615814'
'1d 00:00:1.44000005722046'
'1d 00:00:2.44000005722046'
'1d 00:00:3.44000005722046'
So once 1d is on, I want the hours to turn to 24 and keep going.
Thanks!
Adam Danz
Adam Danz 2019-6-17
Hi Sergio, I updated my answer to address this. Sorry it took some dialog for me to understand what your goal was. My updated answer uses durations rather than datetime.
The updated solution uses durations rather than datetime but it's easy to convert those durations to datetime if that's what you need to do.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by