I want to convert from milliseconds to a date using excell 1904 format

5 次查看（过去 30 天）
Dario Furnari
Dario Furnari 2023-4-6
回答： Steven Lord 2023-4-6
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 ?

请先登录，再回答此问题。

回答（1 个）

Steven Lord
Steven Lord 2023-4-6
Ran in:
baseDate = datetime(0, 'ConvertFrom', 'excel1904')
baseDate = datetime
01-Jan-1904
d = baseDate + milliseconds(1e6)
d = datetime
01-Jan-1904 00:16:40
or
d2 = datetime(1e6, 'ConvertFrom', 'epochtime', ...
'Epoch', 'Jan 1, 1904', ...
'TicksPerSecond', 1000)
d2 = datetime
01-Jan-1904 00:16:40

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by