R: How to handle times without dates?

by

Use the "times" class found in the chron package:

library(chron)

Enter <- c("09:12", "17:01")
Enter <- times(paste0(Enter, ":00"))

Exit <-  c("10:15", "18:11")
Exit <- times(paste0(Exit, ":00"))

Exit - Enter # durations

sum(Enter < "10:00:00") # no entering before 10am
mean(Enter < "10:00:00") # fraction entering before 10am

sum(Exit >  "17:00:00") # no exiting after 5pm
mean(Exit >  "17:00:00") # fraction exiting after 5pm

table(cut(hours(Enter), breaks = c(0, 10, 17, 24))) # Counts for indicated hours   
 ## (0,10] (10,17] (17,24] 
 ##      1       1       0 

table(hours(Enter))  # Counts of entries each hour
## 9 17 
## 1  1

stem(hours(Enter), scale = 2)
## The decimal point is at the |

##   9 | 0
##  10 | 
##  11 | 
##  12 | 
##  13 | 
##  14 | 
##  15 | 
##  16 | 
##  17 | 0

Graphics:

tab <- c(table(Enter), -table(Exit))  # Freq at each time.  Enter is pos; Exit is neg.
plot(times(names(tab)), tab, type = "h", xlab = "Time", ylab = "Freq")
abline(v = c(10, 17)/24, col = "red", lty = 2) # vertical red lines
abline(h = 0)  # X axis

screenshot

More Related Contents:

  1. Convert date-time string to class Date
  2. Find the day of a week
  3. Converting year and month (“yyyy-mm” format) to a date?
  4. Changing date format in R
  5. Convert UNIX epoch to Date object
  6. as.Date with dates in format m/d/y in R
  7. Convert integer to class Date
  8. How to subtract/add days from/to a date?
  9. as.Date returning NA while converting from ‘ddmmmyyyy’
  10. Extracting time from POSIXct
  11. Difference between as.POSIXct/as.POSIXlt and strptime for converting character vectors to POSIXct/POSIXlt
  12. How to subtract years?
  13. R group by date, and summarize the values
  14. Convert decimal day to HH:MM
  15. Collapse / concatenate / aggregate a column to a single comma separated string within each group
  16. What is the difference between require() and library()?
  17. Add column which contains binned values of a numeric column
  18. Replace all 0 values to NA
  19. How to find common elements from multiple vectors?
  20. Generate multiple graphics from within an R function
  21. Calculate group mean, sum, or other summary stats. and assign column to original data
  22. Generate a sequence of the last day of the month over two years
  23. What are the differences between “=” and “
  24. Finding All Positions for Multiple Elements in a Vector
  25. Get filename without extension in R
  26. How convert decimal to POSIX time
  27. Convert hours:minutes:seconds to minutes
  28. R: How to split a data frame into training, validation, and test sets?
  29. Create a time interval of 15 minutes from minutely data in R?
  30. Create a Vector of All Days Between Two Dates

Leave a Comment