Converting Excel Date-Time Formats

gge-ucd / Discussion

Class discussion for R-DAVIS course

0 stars 4 forks source link

Converting Excel Date-Time Formats #17

Closed Denise-Colombano closed 7 years ago

Denise-Colombano commented 7 years ago

Excel assigns Date-Time data with various different formats, for example, 01/01/2017 0:00:00. Does anyone know of a good resource for tidying Date-Time data? For example, to split a single Date-Time cell into 2 separate cells or to assign a Date a Julian date (1-365) to each day in a given year.

Please advise! Thank you.

Denise-Colombano commented 7 years ago

Ok: I found this resource https://stat.ethz.ch/R-manual/R-devel/library/base/html/DateTimeClasses.html in case anyone is interested.