Hi If you really need to have minutes and seconds etc in excel then use a package that can write datetime columns that excel can read eg. access rather that csv. Microsoft is well known for changing dates and date formats - remember excel is a worksheet application not a database - caveat emptor.
If you use a formatted date that excel can recognize then excel has less of a tendency to change it. Datetime is a pain in any language because of the irregularity of time. Beware MS does not get it right if you are using dates from ca 1890 to 1910 Duncan Duncan Mackay Department of Agronomy and Soil Science University of New England Armidale NSW 2351 Email: home: mac...@northnet.com.au -----Original Message----- From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] On Behalf Of Sneha Bishnoi Sent: Wednesday, 20 August 2014 22:14 To: Saurabh Agrawal Cc: r-help Subject: Re: [R] DateTime wrong when exporting to csv in R Tried that..does not help :( On Wed, Aug 20, 2014 at 8:03 AM, Saurabh Agrawal <sagra...@idrcglobal.com> wrote: > Maybe converting POSIXct to character string using "format" before writing > to csv will help. > > > > On 20 August 2014 17:23, Sneha Bishnoi <sneha.bish...@gmail.com> wrote: > >> 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]] >> >> ______________________________________________ >> R-help@r-project.org 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. >> > > -- Sneha Bishnoi +14047235469 H. Milton Stewart School of Industrial & Systems Engineering Georgia Tech [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org 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. ______________________________________________ R-help@r-project.org 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.
