Azzera filtri
Azzera filtri

convert date time to number ?

5 visualizzazioni (ultimi 30 giorni)
MUKESH KUMAR
MUKESH KUMAR il 4 Lug 2018
Commentato: Aarti Dwivedi il 6 Lug 2018
I had excel sheet having date format dd/mm/yyyy hh:mm:ss , So now I want to convert each value into number format. How can I do this?
  2 Commenti
Walter Roberson
Walter Roberson il 4 Lug 2018
Which number format is it?
Does the spreadsheet have the values stored as text string or as excel date format?
Stephen23
Stephen23 il 4 Lug 2018
Modificato: Stephen23 il 4 Lug 2018
Using datetime, datenum, or datevec, depending on your need. What have you tried so far?

Accedi per commentare.

Risposta accettata

Aarti Dwivedi
Aarti Dwivedi il 4 Lug 2018
https://www.mathworks.com/help/matlab/ref/datenum.html Assuming that you have already read the values from the Excel sheet in different variables, the number you are looking for is "numd", it can be obtained using:
date_arr = datetime(yyyy,mm,dd,hh,mm,ss)
numd = datenum(date_arr)
  2 Commenti
Peter Perkins
Peter Perkins il 5 Lug 2018
Unless you specifically need a datenum, this is almost certainly not the best choice. As Walter says, what number format do you need?
And in any case, in recent versions of MATLAB, you can read dates from Excel directly as datetimes, and it's likely that you do not need to convert them to a "number".
Aarti Dwivedi
Aarti Dwivedi il 6 Lug 2018
The OP wanted a "number", that's why I provided it. Although I agree with you that it is not the best choice, I put it with datetime as well as datenum so that it would be clear to a MATLAB novice and the OP the difference between the two.

Accedi per commentare.

Più risposte (0)

Categorie

Scopri di più su Dates and Time in Help Center e File Exchange

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by