If you can make a bit more of a reprex (see here: FAQ: How to do a minimal reproducible example ( reprex ) for beginners ) I can have a look. I would recommend lubridate for any of these things (https://raw.githubusercontent.com/rstudio/cheatsheets/master/lubridate.pdf)