Hi,
Try this:
x<-c(11.00,11.25,11.35,12.01,11.14,13.00,13.25,13.35,14.01,13.14,14.50,14.75,14.85,15.51,14.64)
x[substr(x,4,5)>=60]<-(x[substr(x,4,5)>=60]-.60)+1
res<-sort(as.POSIXct(paste("2012-12-31", sprintf("%.2f",x),sep="
"),format="%Y-%m-%d %H.%M")) #
ifelse(format(res,"%H:%M")>=12, paste(res,"PM"), paste(res,"AM"))
# [1] "2012-12-31 11:00:00 AM" "2012-12-31 11:14:00 AM" "2012-12-31 11:25:00 AM"
#[4] "2012-12-31 11:35:00 AM" "2012-12-31 12:01:00 PM" "2012-12-31 13:00:00 PM"
#[7] "2012-12-31 13:14:00 PM" "2012-12-31 13:25:00 PM" "2012-12-31 13:35:00 PM"
#[10] "2012-12-31 14:01:00 PM" "2012-12-31 14:50:00 PM" "2012-12-31 15:04:00 PM"
#[13] "2012-12-31 15:15:00 PM" "2012-12-31 15:25:00 PM" "2012-12-31 15:51:00 PM"
str(ifelse(format(res,"%H:%M")>=12, paste(res,"PM"), paste(res,"AM")))
#chr [1:15] "2012-12-31 11:00:00 AM" "2012-12-31 11:14:00 AM" ...
str(res)
# POSIXct[1:15], format: "2012-12-31 11:00:00" "2012-12-31 11:14:00" ...
A.K.
----- Original Message -----
From: Christofer Bogaso <bogaso.christo...@gmail.com>
To: r-help@r-project.org
Cc:
Sent: Monday, December 31, 2012 12:12 PM
Subject: [R] Question on creating Date variable
Hello all,
Let say I have following (numeric) vector:
> x
[1] 11.00 11.25 11.35 12.01 11.14 13.00 13.25 13.35 14.01 13.14 14.50 14.75
14.85 15.51 14.64
Now, I want to create a 'Date' variable (i.e. I should be able to do all
calculations pertaining to date/time and also time-series plotting etc.) like
2012-12-31 11:00:00 AM, 2012-12-31 11:25:00 AM, 2012-12-31 11:35:00 AM,
2012-12-31 12:01:00 PM, . . . .
Is it possible to achieve that?
Thanks and regards,
______________________________________________
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.
