MATLAB Answers

Date and number (hour) to times

2 views (last 30 days)
Alex
Alex on 21 Oct 2019
Answered: Ted Shultz on 21 Oct 2019
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 Comments

Show 1 older comment
Stephan
Stephan on 21 Oct 2019
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
Alex on 21 Oct 2019
Of course! Here is the file.

Sign in to comment.

Answers (1)

Ted Shultz
Ted Shultz on 21 Oct 2019
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.

  0 Comments

Sign in to comment.

Sign in to answer this question.