xl_serial_time_conversion: Excel Serial Time Conversion
In LimnoTech/limnotools: Helpful tools for LimnoTech R users

Description Usage Arguments Details Value Author(s) See Also Examples

View source: R/xl_serial_time_conversion.R

Convert serial times from MS Excel to POSIXct format

1	xl_serial_time_conversion(x, unit = NA)

`x`	num serial date
`unit`	a character string specifying a time unit or a multiple of a unit to be rounded to. Valid base units are second, minute, hour, day, week, month, bimonth, quarter, season, halfyear and year. Arbitrary unique English abbreviations as in the `period` constructor are allowed. Rounding to multiple of units (except weeks) is supported. If no unit is specified, unit defaults to "minute".

Converts serial dates from excel into POSIXct dates. round_date takes a date-time object and rounds it to the nearest value of the specified time unit. For rounding date-times which is exactly halfway between two consecutive units, the convention is to round up. Note that this is in line with the behavior of R's round.POSIXt function but does not follow the convention of the base round function which "rounds to the even digit" per IEC 60559.

Returns a POSIXct object

Julie Padilla

round_date