Date and number (hour) to times

3 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
Stephan
Stephan on 21 Oct 2019
Edited: 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.

Categories

Find more on Dates and Time in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!