how to import time/date from excel to matlab and make it comparable as a data?
Show older comments
Dear members,
I have some data in form of time/date and I want to import the data to matlab and do some math works (comparing and changes)! so my question would be if there is any function or method to do this. I would be so thankful.
these are some of data:
06.09.2012 00:00
06.09.2012 00:10
06.09.2012 00:20
06.09.2012 00:30
06.09.2012 00:40
06.09.2012 00:50
Answers (1)
Azzi Abdelmalek
on 9 Oct 2013
0 votes
Use xlsread to import your data from Excell file, then use functions like datenum , datestr to manipulate your date data
3 Comments
Saeed
on 10 Oct 2013
Azzi Abdelmalek
on 10 Oct 2013
Edited: Azzi Abdelmalek
on 10 Oct 2013
It's up to you to use datenum or not. There is no indications about what you want to do with your data
Sam
on 10 Oct 2013
Hi,
I have the same problem.
suppose that you wanna check if you are receiving time data every 10 minutes. In other words, you have to check the date and also the time of input data (I mean comparing them somehow!)
How is that possible? is it possible to check the date and time without converting them to number?! If not, how is it possible to compare these numbers?!
Thanks a lot
Categories
Find more on Calendar in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!