I am using R to read from an excel(csv) file. Within the excel file is a column with the date set that looks likes this: 

  53:40.2
and in the Insert function box it looks likes this:
9/21/2006  4:53:40 PM

I tired separating the time and date using the function below and then plotting again which fail to read properly 
=TEXT(B2,"hh:mm:ss")   and  =TEXT(B9,"mm/dd/yyyy")
 
The R script am using is 
plot.time_vs_id<- function(start,end){
setwd("C:/Documents and Settings/terry/Desktop/r_stuff")
x=read.table("MAV.csv",header=T, sep=",")
plot(x$time[start:end],x$packet_id[start:end],ylab="Packet ID", xlab="Time", type="p")
}

and
plot.hov_Points <- function(start,end){
setwd("C:/Documents and Settings/terry/Desktop/r_stuff")
library(rgl)
t=read.table("MAV.csv",header=T, sep=",")
plot3d(t$time[start:end],t$packet_length[start:end],t$date[start:end], main="potential", xlab="time", ylab="length",zlab="date", type="p")
} 

How can i get R to properly display the time in my graphs 

Thanks 
Terry Bassett  



      
	[[alternative HTML version deleted]]

