How to convert from decimal time to hh:mm:ss

11 次查看（过去 30 天）
Caroline
Caroline 2013-7-29
评论： John Rodriguez 2019-2-21
I am using xlsread to read an excel spreadsheet. One of the values that it is reading is time. Inside the spreadsheet the time is in the correct format (hh:mm:ss), however the value that xlsread returns for the time is a decimal. Does anyone know how to convert this value to the hh:mm:ss format in either MATLAB or C++?
Thanks!

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

采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2013-7-29
datestr(yournumber,'HH:MM:SS')
  3 个评论
显示 1更早的评论
Mohamed Nedal
Mohamed Nedal 2017-11-22
Hello Azzi, I've tried your answer on this time ( 2637 minutes) but I've got
00:00:00
Could you please tell me how to convert this time in this case?
John Rodriguez
John Rodriguez 2019-2-21
I'm getting the same result. My data is in the format HHMMSS and I want it to go to HH:MM:SS. I'm now just getting 00:00:00 for my full array.

请先登录，再进行评论。

更多回答（2 个）

Jan
Jan 2013-7-29
编辑：Jan 2013-7-29
Microsoft has bee so smart to invent two different serial date numbers: One for Windows and one for Macs.
if ismac
MatlabDate = datestr(ExcelDateNum + 695422, 13);
else
MatlabDate = datestr(ExcelDateNum + 693960, 13);
end
Unfortunately this is very wrong, because it does not matter, if the current computer is a Mac, but if the Excel file was stored on a Mac. But I do not know a method to find out this detail.
Peter Perkins
Peter Perkins 2017-11-29
Unless you are using an older version of MATLAB, you are likely better off using readtable (instead of xlsread) and datetime (instead of datestr and datenum). Even if you use xlsread to read Excel serial date numbers, you can use
dates = datetime(excelDates,'ConvertFrom','excel') % or 'excel1904'
  2 个评论
Tunga Rangaswamy
Tunga Rangaswamy 2018-12-5
编辑：Tunga Rangaswamy 2018-12-5
This works great! It produces date in day-month-year format and time in hh:mm:ss format. How do I get time in hh:mm:ss.mmm (including milliseconds)?
Peter Perkins
Peter Perkins 2018-12-11
Assuming you mean "the time portion of a datetime", you'd need to set the Format property to include HH:mm:ss.SSS. Look at the documentation for datetime.Format.

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by