Convert Decimal to HH: MM

Question

I have a decimal number: 0.8541667and I want to convert it to the format HH: the MM, using R. The answer that I'm looking for is: 20:30.

Answer 1

Try the following:

R> format(as.POSIXct(Sys.Date() + 0.8541667), "%H:%M", tz="UTC")
[1] "20:30"
R> 

We start with a date - which can be any date, so we use today - and add the desired fractional day.

Then we convert the Date type to a Datetime object.

Finally, we format the time and minute parts of the Datetime object, ensuring that UTC is used for the time zone.

Answer 2

Usage chron:

chron::times(0.8541667)
#[1] 20:30:00

Answer 3

data.table:

> library(data.table)
> structure(as.integer(0.4305556*60*60*24), class="ITime")
[1] "10:20:00"

; ; ITime. (ITime .)

:

• @GaborGrothendieck re chron package and a link to his R News article with Thomas Petzoldt about converting, in particular, from Excel Converting a decimal / fraction representing days to its actual time in R?
• @JorisChau re RStudio hms package how to convert excel internal coding for clock to clock in R?