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

Question

Caroline 2013-7-29

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/83440-how-to-convert-from-decimal-time-to-hh-mm-ss

评论： 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!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Azzi Abdelmalek 2013-7-29

6
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/83440-how-to-convert-from-decimal-time-to-hh-mm-ss#answer_93003

在 MATLAB Online 中打开

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

3 个评论
显示 1更早的评论隐藏 1更早的评论

Mohamed Nedal 2017-11-22

在 MATLAB Online 中打开

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 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.

请先登录，再进行评论。

Answer 2

Jan 2013-7-29

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/83440-how-to-convert-from-decimal-time-to-hh-mm-ss#answer_93015

编辑：Jan 2013-7-29

在 MATLAB Online 中打开

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 3

Peter Perkins 2017-11-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/83440-how-to-convert-from-decimal-time-to-hh-mm-ss#answer_293811

在 MATLAB Online 中打开

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 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 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.

请先登录，再进行评论。