Convert a decimal number to HH:MM:SS in R

Question

I have a series of decimal numbers (marathon race split times): 64.90, etc., and I want to convert it into HH:MM:SS format using R so that I can us the result to do time math. The answer I am looking for is: 1:04:54.

chron doesn't seem to be doing what I'm expecting it to do.

chron::times(64.90) Time in days: [1] 64.9

First time on this site, so be kind. Thanks.

score 3 · Answer 1 · answered Mar 03 '18 at 19:49

3

chron times are measured in days and since you apparently have minutes divide the input by the number of minutes in a day:

library(chron)

times(64.90 / (24 * 60))
## [1] 01:04:54

answered Mar 03 '18 at 19:49

G. Grothendieck

254,981
17
203
341

score 2 · Answer 2 · answered Mar 03 '18 at 19:45

2

You could try lubridate::seconds_to_period

library(lubridate)
seconds_to_period(64.90)
[1] "1M 4.90000000000001S"

answered Mar 03 '18 at 19:45

moodymudskipper

46,417
11
121
167

Is it possible to remove seconds digits (without regex)? Thanks – Mostafa90 Mar 18 '21 at 14:08

score 2 · Answer 3 · answered Mar 03 '18 at 19:47

2

library(hms)
as.hms(64.90*60)

output

01:04:54

answered Mar 03 '18 at 19:47

vsb

428
6
15

Convert a decimal number to HH:MM:SS in R

3 Answers3

Linked