how to extract duration from datetime columns

General
1

i have two columns with datetimes and i want to find the duration by subtracting end time from start time in a new column as days + hours + minutes format. how do i do that?

2

Here it is in years. Do what you need to get months and days out of it.

library(lubridate)
library(tidyverse)

tibble(start = ymd_hms("2009-03-08 01:59:00"),
             end = ymd_hms("2012-02-29 12:00:00")) %>% 
  mutate(years = interval(start, end) / years(1))
1 Like
3

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.