I am attempting to import a schedule in xlsx format into Monday and the hour (which is a text data type in the xlsx), is being pushed forward an hour (i.e., 6 being changed to 7, 7 to 8, etc). The dates on the schedule all take place sometime between March 12-November 5 (daylight savings). The date format in the xlsx is Y-M-D H:M:S
I also have an issue when importing the same file where it will only list the month and day when importing. I want the time to be displayed as well.
Let me know if you have encountered this before and/or if you need additional information. Thank you.