Hi I have checked the time 1 in my desktop with tde and excel. same time i am getting correct values. please re try yourself.
I assume you are using time 1 as string only, thereby viewing it perfectly fine.
While in my case, for some of the graphs, I might have to use it as "date & time" parameter as well.
So converting the data type to" date & time", for live connection hourly input is coming fine, but for TDE it is showing as null only