You are now following this question
- You will see updates in your followed content feed.
- You may receive emails, depending on your communication preferences.
Please advice how to convert date array to seconds format
3 views (last 30 days)
Show older comments
here by attaching date formats and their respective code, kindly advice how can i convert it to seconds form as attached..
Data=readtable('axeaload.xlsx');
testdates = Data{1:end,1};
date_num = datenum(testdates);
14 Comments
Walter Roberson
on 18 Jan 2021
Seconds since what time?
Or based upon what input?
datenum reflect full days. Seconds on the order of 120 reflect approximately every 2 minutes.
It seems more likely that you have a duration of some kind inside your xlsx file.
NN
on 18 Jan 2021
thanks for your reply .I have attached the excel file .Please check
But i understand it is hourly basis in excel file
Walter Roberson
on 18 Jan 2021
Might I suggest that what you want is minutes and not seconds?
Data = readtable('axeaload.xlsx');
dt = Data{:,1} + hours(Data{:,2});
minutes_inside_day = minutes(dt - dateshift(dt, 'start', 'day'));
minutes_since_start = minutes(dt - dateshift(dt(1), 'start', 'day'));
Depending what you are trying to do.
If you are wanting to do minutes inside the day, then a simpler way is just
minutes_inside_day = Data{:,2} * 60;
NN
on 18 Jan 2021
Thank you it works, but why it shows from 120,then 180...
Its not showing 60 sec initially !
Walter Roberson
on 18 Jan 2021
... It doesn't start with 120 ?
Data = readtable('axeaload.xlsx');
dt = Data{:,1} + hours(Data{:,2});
minutes_inside_day = minutes(dt - dateshift(dt, 'start', 'day'));
minutes_since_start = minutes(dt - dateshift(dt(1), 'start', 'day'));
minutes_inside_day(1:3)
ans = 3×1
60
120
180
minutes_since_start(1:3)
ans = 3×1
60
120
180
minutes_inside_day = Data{:,2} * 60;
minutes_inside_day(1:3)
ans = 3×1
60
120
180
Perhaps the 60 scrolled off your command window and you need to scroll back to see it?
Walter Roberson
on 18 Jan 2021
Try
Data = readtable('axeaload.xlsx', 'readvariablenames', false);
I speculate you might be using an older version that tended to be weaker in figuring out whether the first line was variable names or not.
NN
on 19 Jan 2021
I request you to look into the below query as well.
When i import time series data from matlab to simulink,it appears as individual data not as corresponding to time.(image attached).
i used the below format for below workspace
[time Youtput]
time and Youtput are 1*360 double format
NN
on 19 Jan 2021
this has been posted here :
https://www.mathworks.com/matlabcentral/answers/720499-importing-data-rom-matlab-to-simulink
Answers (0)
See Also
Categories
Find more on Time Series Objects in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!An Error Occurred
Unable to complete the action because of changes made to the page. Reload the page to see its updated state.
Select a Web Site
Choose a web site to get translated content where available and see local events and offers. Based on your location, we recommend that you select: .
You can also select a web site from the following list
How to Get Best Site Performance
Select the China site (in Chinese or English) for best site performance. Other MathWorks country sites are not optimized for visits from your location.
Americas
- América Latina (Español)
- Canada (English)
- United States (English)
Europe
- Belgium (English)
- Denmark (English)
- Deutschland (Deutsch)
- España (Español)
- Finland (English)
- France (Français)
- Ireland (English)
- Italia (Italiano)
- Luxembourg (English)
- Netherlands (English)
- Norway (English)
- Österreich (Deutsch)
- Portugal (English)
- Sweden (English)
- Switzerland
- United Kingdom (English)
Asia Pacific
- Australia (English)
- India (English)
- New Zealand (English)
- 中国
- 日本Japanese (日本語)
- 한국Korean (한국어)