Hi,

I noticed that whenever I import an excel file that contains a time or datetime variable onto Stata (time up to seconds), the values for those variables in Stata appear to be slightly off sometimes (generally by a second). I understand that there is a difference in the way Excel and Stata read dates and times and there might be some rounding issue at play here. I am looking for a way for Stata to read the excel time/datetime variables accurately. I see some similar questions and documentation online that address my question but I am still a little confused. Any help with this would be appreciated. Thank you!