On 18/06/09 07:34, Shreyasee wrote:
Hi,
The dataset has four time variables.
Each variable has data in "1/6/2006 12:58:55 PM" format.
I applied the subtraction function (=E2-D2) for calculating difference
between variable1 and variable2 for each record.
I copied those values and pasted in another column using "Paste
special -> values" option.
Then I imported the dataset into R and tried to plot histogram for
this new column.
Sounds like you have problems with Excel: this is the wrong mailing list
for that. You should definitely change the formatting of your Excel
difference column, but better to import the dates to R and do the
difference there. But as I said: this is the wrong list for Excel problems.
Allan
______________________________________________
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.