Hi All!
This seems to be trival but I am not able to find a solution for it.
I have a dataframe with datetime columns in form of ("%d/%m/%y %H:%M:%OS").
I write it to csv file. Whne i open the csv file the date time format are
in some number form .
So even if I use custome settings from excel to change it into date time
format, it gives me wrong value.
My data frame is as below:
PostDate Status ArrTime
NumGuests
2014-08-14 16:13:08.850 O 2012-01-13 00:00:00.000
6
2014-08-14 16:13:08.850 A
-SB
[[alternative HTML version deleted]]
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.