timeExcel_Posix: Time values in Excel spreadsheets are imported as Posix
In duanxd1/gfuns: My Global Functions
Description
Defaults to the origin date and UTC timezone of microsoft excel which is non-standard 1899-12-31. This function extracts the hour, minute, second values and creates a lubridate hms object with specified timezone which can then be combined with _Date to generate _DateTime value Timezone Etc/GMT-6 is Eastern Standard Time
Usage
1
2
3
4
5
6
7
timeExcel_Posix(
date_,
time_,
TZin = "UTC",
TZout = "Etc/GMT+5",
origin = as.POSIXct("1899-12-31", tz = "UTC")
)
Arguments
date_
POSIX date
time_
POSIX time
TZin
original timezone
TZout
output timezone
origin
date/time origin
duanxd1/gfuns documentation built on March 7, 2020, 12:46 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description
Defaults to the origin date and UTC timezone of microsoft excel which is non-standard 1899-12-31. This function extracts the hour, minute, second values and creates a lubridate hms object with specified timezone which can then be combined with _Date to generate _DateTime value Timezone Etc/GMT-6 is Eastern Standard Time
Usage
1 2 3 4 5 6 7 | timeExcel_Posix(
date_,
time_,
TZin = "UTC",
TZout = "Etc/GMT+5",
origin = as.POSIXct("1899-12-31", tz = "UTC")
)
|
Arguments
date_ |
POSIX date |
time_ |
POSIX time |
TZin |
original timezone |
TZout |
output timezone |
origin |
date/time origin |
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.