Skip to content

Instantly share code, notes, and snippets.

@verajosemanuel

verajosemanuel/excel_time_number_to_gmt.R

Last active February 15, 2019 10:48
Show Gist options
  • Save verajosemanuel/5c31702914ff2e121750fbe6fab9ae21 to your computer and use it in GitHub Desktop.
Save verajosemanuel/5c31702914ff2e121750fbe6fab9ae21 to your computer and use it in GitHub Desktop.
Download ZIP
#Excel time to GMT time in #R #timeseries #wrangling
Raw
excel_time_number_to_gmt.R
df$date_d1 <- as.character(as.Date(as.POSIXct((as.numeric(as.character(df$date_d1)) * 86400), origin = "1899-12-30", tz = "GMT")))
# using janitor
janitor::excel_numeric_to_date(17933)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment