Date and number (hour) to times

2 Ansichten (letzte 30 Tage)
Alex
Alex am 21 Okt. 2019
Beantwortet: Ted Shultz am 21 Okt. 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 Kommentare
Stephan
Stephan am 21 Okt. 2019
Bearbeitet: Stephan am 21 Okt. 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 am 21 Okt. 2019
Of course! Here is the file.

Melden Sie sich an, um zu kommentieren.

Antworten (1)

Ted Shultz
Ted Shultz am 21 Okt. 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.

Kategorien

Mehr zu Dates and Time finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by