topic Importing Time values from excel using append tool in Python Questions https://community.esri.com/t5/python-questions/importing-time-values-from-excel-using-append-tool/m-p/112866#M8801 <HTML><HEAD></HEAD><BODY><P>I'm a newb and I'm trying to design a feature dataset for my geodatabase with domains and subtypes so I can catch errors in my data as I import it from excel. So far this has been working, but I hit a&nbsp;minor snag with my time field. I have an excel sheet that has time values (formatted as time values in excel - as 24 format) . When I run the append tool, it&nbsp;works, but since I have time values set to format "date" - it gives the year as 12/30/1899 - which is obviously wrong. Should I format the time cell in a different format (e.g. long, string, text) or would it make more sense to combine these two columns (date &amp; time) in my original excel sheet and then import it that way?&nbsp;<BR /><BR />Or is there a way to combine these two fields in my feature class without having to alter my original excel sheet?&nbsp;<BR /><BR />Thank you!&nbsp;</P></BODY></HTML> Mon, 13 May 2019 11:46:25 GMT BradleyNissen 2019-05-13T11:46:25Z Importing Time values from excel using append tool https://community.esri.com/t5/python-questions/importing-time-values-from-excel-using-append-tool/m-p/112866#M8801 <HTML><HEAD></HEAD><BODY><P>I'm a newb and I'm trying to design a feature dataset for my geodatabase with domains and subtypes so I can catch errors in my data as I import it from excel. So far this has been working, but I hit a&nbsp;minor snag with my time field. I have an excel sheet that has time values (formatted as time values in excel - as 24 format) . When I run the append tool, it&nbsp;works, but since I have time values set to format "date" - it gives the year as 12/30/1899 - which is obviously wrong. Should I format the time cell in a different format (e.g. long, string, text) or would it make more sense to combine these two columns (date &amp; time) in my original excel sheet and then import it that way?&nbsp;<BR /><BR />Or is there a way to combine these two fields in my feature class without having to alter my original excel sheet?&nbsp;<BR /><BR />Thank you!&nbsp;</P></BODY></HTML> Mon, 13 May 2019 11:46:25 GMT https://community.esri.com/t5/python-questions/importing-time-values-from-excel-using-append-tool/m-p/112866#M8801 BradleyNissen 2019-05-13T11:46:25Z