Converting excel DateTime serial number to R DateTime

by

Your number is counting days. Convert to seconds, and you’re all set (less a rounding error)

helpData[["ExcelDate"]] <- 
  as.POSIXct(helpData[["ExcelNum"]] * (60*60*24)
    , origin="1899-12-30"
    , tz="GMT")


#     ID        DateTime ExcelNum           ExcelDate
#  1   1   3/4/2011 6:00 40606.25 2011-03-04 06:00:00
#  2   2  3/11/2011 7:55 40613.33 2011-03-11 07:54:59
#  3   3  3/13/2011 7:55 40615.33 2011-03-13 07:54:59
#  4   4  3/14/2011 0:00 40616.00 2011-03-14 00:00:00
#  5   5 3/14/2011 10:04 40616.42 2011-03-14 10:03:59
#  6   6  3/14/2011 7:55 40616.33 2011-03-14 07:54:59
#  7   7 3/15/2011 19:55 40617.83 2011-03-15 19:54:59
#  8   8  3/17/2011 7:55 40619.33 2011-03-17 07:54:59
#  9   9  3/18/2011 4:04 40620.17 2011-03-18 04:03:59
#  10 10  3/18/2011 4:04 40620.17 2011-03-18 04:03:59

More Related Contents:

  1. How can the facet function in ggplot be used to create a histogram in order to visualize distributions for all variables in a dataset?
  2. How can I find compound words, removing spaces between them and replace them in my corpus?
  3. Faster ways to calculate frequencies and cast from long to wide
  4. How can I remove all duplicates so that NONE are left in a data frame?
  5. strptime, as.POSIXct and as.Date return unexpected NA
  6. How to delete a row by reference in data.table?
  7. Measuring function execution time in R
  8. R – Concatenate two dataframes?
  9. Error in plot.new() : figure margins too large in R
  10. Generate a repeating sequence based on vector
  11. anova test fails on lme fits created with pasted formula
  12. How can we make xkcd style graphs?
  13. lib unspecified & Error in loadNamespace
  14. Replace values in a vector based on another vector
  15. Join R data.tables where key values are not exactly equal–combine rows with closest times
  16. Reasons that ggplot2 legend does not appear [duplicate]
  17. set ggplot plots to have same x-axis width and same space between dot plot rows
  18. lapply-ing with the “$” function
  19. How to change the first row to be the header in R?
  20. Insert a logo in upper right corner of R markdown pdf document
  21. How to replace NA (missing values) in a data frame with neighbouring values
  22. remove kernel on jupyter notebook
  23. Get date difference in years (floating point)
  24. Numbers as column names of data frames
  25. In R, how can I check if two variable names reference the same underlying object?
  26. How to pass “nothing” as an argument to `[` for subsetting?
  27. Spacing between boxplots in ggplot2
  28. Configuring compilers on Apple silicon (Big Sur, Monterey, Ventura) for Rcpp and other tools
  29. Creating a vertical color gradient for a geom_bar plot
  30. Recommended package for very large dataset processing and machine learning in R [closed]

Leave a Comment