Time format conversion command

T
T
2012 10 16
2 个回答
回答已采纳
3 次查看（30 天）

0 个投票

This post is related to this thread:
http://www.mathworks.com/matlabcentral/answers/51019-synchronize-time-from-a-database-and-csv-file-and-plot
If I want to convert
36:40.0
to
time in seconds, how do I do this?

2 个评论
显示 无 隐藏 无

Matt Fig
Matt Fig 2012-10-16
What form is that? Is it a string and many in a character array or a cell array or what?
A = ['36:40.0';'36:41.0';'34:40.3']; % Like this?
A = {'36:40.0';'36:41.0';'34:40.3'}; % Like this?
Azzi Abdelmalek
Azzi Abdelmalek 2012-10-16
are your data in a text file?

请先登录，再进行评论。

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

 采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2012-10-16
编辑：Azzi Abdelmalek 2012-10-16

0 个投票

t={'36:40.0' ,'37:40.0' ;'39:40.0' ,'31:40.0'}
out=cellfun(@(x) sum(cellfun(@str2double, regexp(x,'[:.]','split')).*[3600 60 1]),t)

7 个评论
显示 5更早的评论 隐藏 5更早的评论

Azzi Abdelmalek
Azzi Abdelmalek 2012-10-16
look at edited answer
Azzi Abdelmalek
Azzi Abdelmalek 2012-10-17
编辑：Azzi Abdelmalek 2012-10-17
post a sample of data
data{2} is not a cell array while t is
Azzi Abdelmalek
Azzi Abdelmalek 2012-10-17
Because you've added a 1/100 sec. I have to change [3600 60 1]
Azzi Abdelmalek
Azzi Abdelmalek 2012-10-17
编辑：Azzi Abdelmalek 2012-10-17
try
out=cellfun(@(x) sum(cellfun(@str2double, regexp(x,'[:.]','split')).*[3600 60 1 1/100]),data{2})
Azzi Abdelmalek
Azzi Abdelmalek 2012-10-17
Different does'nt say which one is correct
Azzi Abdelmalek
Azzi Abdelmalek 2012-10-18
编辑：Azzi Abdelmalek 2012-10-18
Anthony, I suggest that you reformulate and repost your question, let it brief and very clear.
T
T 2012-10-18
Actually I used the following:
[Y, M, D, H, MN, S] = datevec(data{2}); out = H*3600+MN*60+S;
It works!

请先登录，再进行评论。

更多回答（1 个）

Matt Fig
Matt Fig 2012-10-16
编辑：Matt Fig 2012-10-16

0 个投票

If you have a cell array, I would do this:
A = {'36:40.0';'36:40.1';'34:40.3'}; % A cell array
B = '${num2str(str2num($1)*60+str2num($2))}';
B = regexprep(A,'(\d+):(\d+\.\d*)',B)
If you have a character array, then:
A = ['36:40.0';'36:41.0';'34:40.3']; % A character array.
B = '${num2str(str2num($1)*60+str2num($2))}';
B = char(regexprep(cellstr(A),'(\d+):(\d+\.\d*)',B))

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

Matt Fig
Matt Fig 2012-10-16
编辑：Matt Fig 2012-10-16
I do not understand what you mean, "not CSV file has a time column like this."
If you read the file into a cell array or a character array, the corresponding code I gave you will convert it regardless of the range as long as it is MM:SS.F format (minutes:seconds.fraction)...
For example:
A = {'36:40.0','36:40.1','36:40.2','40:10.3','43:50.1'};
Now run the code I showed above in the first part.
B = '${num2str(str2num($1)*60+str2num($2))}';
B = regexprep(A,'(\d+):(\d+\.\d*)',B)
B =
'2200' '2200.1' '2200.2' '2410.3' '2630.1'
Matt Fig
Matt Fig 2012-10-16
编辑：Matt Fig 2012-10-16
You seem to show where you converted to datenumbers using the DATENUM command. So why would it be surprising that you get datenumbers?
Show what this shows:
data{2}(1:3) % Or, what is in data{2}... strings?
If you don't see the strings in there, take the time to explore the data cell array before you run all these conversions on it. What is in data{1}? How about data{3}, etc...
Matt Fig
Matt Fig 2012-10-16
编辑：Matt Fig 2012-10-16
Please show the first few elements of data{2}. Do so in another comment, don't go up and edit old comments or I cannot follow the conversation.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by