I want to conver the excel dateformat('27-03-2013 06:00:00') in to matlab yearday i.e 31 jan 2013 = 31 and `1st Feb 2013 = 32

2 次查看（过去 30 天）
Bikiran Das
Bikiran Das 2016-7-11
评论： Peter Perkins 2016-8-3
need to convert excell date ('27-03-2013 06:00:00') format into Matlab datevec or datestr and then further conver it into year day format which of the type 40.5 which means 9th Feb afternoon. where the number after the decimal refers to time.

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

采纳的回答

Julian
Julian 2016-7-11
Consider:
t = {'27-03-2013 06:00:00' % in text form, apparently from Excel
'09-02-2013 12:00:00' } % an example mentioned in question
t = datetime(t, 'Inputformat', 'dd-MM-yyyy HH:mm:ss') % becomes MATLAB datetime
ival = t - datetime(year(t), 1, 1) % becomes elapsed interval since the start of the year (1st Jan same year)
ival = days(ival) % we're just interested in the number of days
result = double(ival)+1 % convert into standard number, adding 1 because 01-Jan is day 1 not day 0
Note that datetime can process numeric Excel dates directly. I inferred from your question you want the relative day number for any year, starting at day 1 on 1st Jan.
Hope this helps
Julian.
  3 个评论
显示 1更早的评论
Peter Perkins
Peter Perkins 2016-8-3
Depending on what you want to do with "40.5", you might just leave the duration alone. Reusing Julian's example:
>> s = {'27-03-2013 06:00:00' '09-02-2013 12:00:00'};
>> t = datetime(s, 'Inputformat', 'dd-MM-yyyy HH:mm:ss');
>> dt = t - dateshift(t,'end','year','previous')
dt =
2070:00:00 972:00:00
>> dt.Format = 'd'
dt =
86.25 days 40.5 days
Or you can go all the way to numeric:
>> d = days(dt)
d =
86.25 40.5

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by