Date and number (hour) to times

3 vues (au cours des 30 derniers jours)
Alex
Alex le 21 Oct 2019
Réponse apportée : Ted Shultz le 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 commentaires
Afficher 2 commentaires plus anciens
Stephan
Stephan le 21 Oct 2019
Modifié(e) : Stephan le 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 le 21 Oct 2019
Of course! Here is the file.

Connectez-vous pour commenter.

Connectez-vous pour répondre à cette question.

Réponses (1)

Ted Shultz
Ted Shultz le 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.
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

Catégories

En savoir plus sur Dates and Time dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by