Date and Time format problem in excel for Smart Client
I am facing a problem with Date & Time format for Smart Client Excel interface. In excel I am getting real time value and log value both. But from log value I am facing this problem. Under Time stamp the value is coming like this: 41304.83333. In excel I can select format of the cell either for Date or for time so I am not abale to get both date and time from this decimal value.
Whether there is any setting to get the correct format?
If I am right ,the Time stamp value 41304.83333 if we convert to time it will be 30/01/2013 , 8:00pm, ( This conversion I got from excel Sheet only)
It seems to be excel sheet cell property problem canyou please cross check.
Copy the excel sheet --> Rename It and try to change the Property of cells fro General to time/date.
This helpful to you