I want to convert from milliseconds to a date using excell 1904 format
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
so i have a vector of millisecond, and I want to convert in one date. The standard utilizated for caught this time is the excell 1904, there exsist something that convert it automaticalli on matlab ?
0 commentaires
Réponses (1)
Steven Lord
le 6 Avr 2023
baseDate = datetime(0, 'ConvertFrom', 'excel1904')
d = baseDate + milliseconds(1e6)
or
d2 = datetime(1e6, 'ConvertFrom', 'epochtime', ...
'Epoch', 'Jan 1, 1904', ...
'TicksPerSecond', 1000)
0 commentaires
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!