Overall goal: I'd like to have a visual representation of when certain computer applications are running over the course of a day (data will come from a SQL query later, but I'm using a csv for now). My idea is to use a gantt chart, but I'm running into issues with the start and end time. I'm wondering if it's because I need to use hours instead of days as my unit of time.
Problem #1 I'm trying to use strptime to convert a datetime string (7/12/2010 5:30:05 PM) to POSIX so I can use it as a start/end time in a gantt chart. ( I need to measure hours instead of days, so as.POSIXct/lt won't work for me. I'd also like to retain date info so I can create weekly/monthly averages)) When tested, I get this: > strptime("7/12/2010 5:30:05 PM", "%X") [1] NA When I delete the date, I get: > strptime("5:30:05 PM", "%X") [1] "2010-07-30 05:30:05" The full date string in the first example seems pretty unambiguous, so I'm not sure why it is not being recognized and %X should show the full datetime string - any suggestions? #2 I will read the data from a csv file (and eventually, a database). A secondary problem I've run into is converting the entire list of times - will I need to create a loop to handle them all or is there a function similar to tapply() that I can use? Thanks in advance for your time, akn [[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.