excel decimal time conversion

5 ビュー (過去 30 日間)

David C 2013 年 3 月 28 日

I have a PW protected excel spreadsheet that has a date/time column, but formatted as "general"

using xlsread, the timestamps (ie 8:51:42) are read into matlab as the numberic formatted time of 0.3692

How do you convert this decimal into the actual time?

datestr(0.3692) gives 1:15 PM and not the 8:51:42 that I expected to get

All help is appreciated!

Azzi Abdelmalek 2013 年 3 月 28 日

datestr(0.3692,'HH:MM:SS')

David C 2013 年 3 月 28 日

as i mentioned above, datestr gives a different answer

must have something to do with how excel converts a time into a decimal :(

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

Help Center および File Exchange で Spreadsheets についてさらに検索

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

Translated by