Date and number (hour) to times

2 次查看（过去 30 天）

Alex 2019-10-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/486624-date-and-number-hour-to-times

回答： Ted Shultz 2019-10-21

I have two columns: First - Date (for example, 24-Jun-2015); Second - Hour for that Date (for example, 9, i.e., just a number of the hour). Can somebody tell me how I can convert these two pieces of information into ONE date?

4 个评论
显示 2更早的评论隐藏 2更早的评论

Stephan 2019-10-21

编辑：Stephan 2019-10-21

please give us data that we can work with instead of screenshots - a .mat-file attached to a comment or your question, will help us to help you...

Alex 2019-10-21

HourlyData.mat

Of course! Here is the file.

请先登录，再进行评论。

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

回答（1 个）

Ted Shultz 2019-10-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/486624-date-and-number-hour-to-times#answer_397520

If you convert the date column to datetime, and the hour column to a duration of hours, then you simply add them together to get a new datetime. This datetime can be converted to anything you like.

https://www.mathworks.com/help/matlab/ref/datetime.html

https://www.mathworks.com/help/matlab/ref/duration.hours.html

https://www.mathworks.com/help/matlab/ref/duration.html