Jul 26 2021 10:50 AM
Hello,
I am having issues converting a custom date/time to another format. The original column consists of a time set as follows:
7/9/2019 6:00 |
7/9/2019 6:15 |
7/9/2019 6:30 |
7/9/2019 6:45 |
7/9/2019 7:00 |
7/9/2019 7:15 |
7/9/2019 7:30 |
7/9/2019 7:45 ... continued to 12/31/19 23:45 |
But I am trying to automatically change it to hourly for the entire year. Basically changing 15 min to hourly for an annual time set. The dates mess up when dragging the set dates down the column.
7/9/2019 6:00 |
7/9/2019 7:00 |
7/9/2019 8:00 |
7/9/2019 9:00 |
7/9/2019 10:00 |
7/9/2019 11:00 |
7/9/2019 12:00 ... continued to 12/31/2019 23:00 |
Jul 26 2021 12:05 PM
It's not clear you'd like to convert first column to another or create new column with datetime. If the latest you may enter first datetime into the cell, in one below add to it 1/24 and drag down.
If first, what is the logic of transformation?
Jul 26 2021 01:26 PM
If created in a new column, you can try to use formula: =TEXT(MONTH(A4)&"/"&DAY(A4)&"/"&YEAR(A4)&" "&HOUR(A4)&":00","dd/mm/yyyy h:mm")+0
Jul 27 2021 05:11 AM
If you drag this formula down it will be 4 cells with 6:00 time, 4 with 7:00, etc. But it shall be one cell for each hour.