I see that the format that we receive the ‘start’ and ‘end’ metadata has changed (see screenshot).
Unfortunately, it seems to have become impossible to isolate the time component of ‘start’ and ‘end’ in Excel. If you try and use ‘text to columns’ for example, the output doesn’t make much sense.
Stata also seems to only import the date component and not time.
Could you please help me figure out how I can isolate the time component or get Excel to recognize the time part?