@Aquarock
Happy to.
The short answer is that I used the wrong date for the Microsoft epoch.
The long answer is:
All dates in Excel (and many software solutions) are stored as seconds since their epoch. In this case Excel is using the Microsoft epoch. See https://en.wikipedia.org/wiki/Epoch_(computing)#Notable_epoch_dates_in_computing
In your case, you have entered your date in hh:mm:ss and told Excel that it is a date time format. As a result Excel stores the integer value for the number of seconds represented by the hours, minutes, and seconds you gave it. but doesn't have any other date information so it in effect thinks that date value you provided is in the first week of 1900.
When Alteryx is reading the fields, Microsoft Excel tells Alteryx that the file is a date time format and provides the full date time value to Alteryx.
To correct for the fact that we don't have dates associated with the data, we need Alteryx to back solve for the number of seconds that Microsoft actually had stored between the Microsoft epoch and the date time format it provided to Alteryx. Once we have that number of seconds it is fairly straight forward to get the time into hours, minutes, and seconds.
We then needed to create a string containing the values you had because Alteryx doesn't have a time format that allows for more than 24 hours to my knowledge.
