Create a numeric variable DATE+HOUR
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Hi. I hope you're ok.
I write this question because I want to create a new numeric variable which contains the date (i.e. 12/09/2019) and the hour (i.e. 01:15:20). I did this in Excel and the result is given in the following photo:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/512397/image.png)
However, If I try to do this in MATLAB (R19b) the result is quite different.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/512402/image.png)
Can you tell me if I'm doing something wrong? I don't know if the sintaxis of the date and hour are correct, and if not, what's wrong with that (I want the result given in my Excel sheet).
Thanks!
David
0 Commenti
Risposta accettata
Adam Danz
il 7 Feb 2021
Modificato: Adam Danz
il 7 Feb 2021
There's rarely a good reason to use datenum rather than datetime values. See Why are datetime arrays better than datenum?
% Convert to datetime
Time = '01:15:02 12/09/19';
datetime(Time,'InputFormat','HH:mm:ss MM/dd/yy')
Date numbers in Excel represent the number of days since Jan 1 1900 whereas date numbers in Matlab represent the number of days since Jan 1,0000 so there's a 693960 day difference (see documentation).
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Dates and Time in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!