Convert Excel String time to number
2 次查看(过去 30 天)
显示 更早的评论
My excel spreadsheet that I am reading into matlab with xlsread has text for the time in the format of 11:23:23 AM for example. this is a string with no date associated with it so when I try and run datenum or datevec I get an error Failed to lookup month of year. I also tried str2double but that just gives me a series of NaN . What am I looking to do? I need to convert a series of times in an array and then compute the elapsed time among other things.
0 个评论
回答(2 个)
Ken Atwell
2014-10-30
This is not pretty, but you can split the string on the ':' and compute the number of seconds since midnight. The code below used cellfun to vectorize the code; a for loop could be use and might be easier to understand (but likely sacrificing performance).
testData = repmat({'11:23:23'}, [10,1]);
hms = cellfun(@(x) str2double(strsplit(x, ':')), testData, 'UniformOutput', 0);
cellfun(@(x) x(1)*60*60+x(2)*60+x(3), hms)
You can compute duration so long as events don't cross midnight. If events do cross midnight, things become more complicate. In that case, if you have R2014b, the new datetime/duration functions may be useful. Here is a intro video.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Calendar 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!