Home > Software engineering >  How to extract the hour component in R
How to extract the hour component in R

Time:01-05

I have following code and as you can see system calculating the difference correctly, but I would like consider only first 5 character i.e. 3.449 etc and I like to discard the 'hours' part. Once I try to convert the same as character, then it not working. Any help will be appreciated.

library(dplyr)

df %>%
  mutate(difference = difftime(DateTime_Stat, DateTime_End, units = 'hours'))

#       DateTime_Start        DateTime_End     difference
#1 2021-02-02 16:42:11 2021-02-02 16:43:15 0.000000 hours
#2 2021-02-02 20:10:14 2021-02-02 20:11:55 3.449754 hours

I have tried to convert the value to character type so I can use substr() to extract the values but system is failing to convert it to as character.

CodePudding user response:

You can convert to numeric and round:

round(as.numeric(df$difference), 3)
  • Related