p_excel_dt: Parse Excel Numeric Date/Time

In decisionpatterns/coercion: Utilities for Coercing (and Parsing) Values Between Types, Modes and Classes

Description

Parse Excel Numeric Date/Time

Usage

p_excel_dt(x)

## Default S3 method:
p_excel_dt(x)

## S3 method for class 'numeric'
p_excel_dt(x)

## S3 method for class 'Date'
p_excel_dt(x)

## S3 method for class 'POSIXct'
p_excel_dt(x)

## S3 method for class 'character'
p_excel_dt(x)

Arguments

x	numeric; vector of Excel date/times expressed as numeric

Details

At times readxl::read_excel does not get the date and times right and imports them as numeric instead. This converts those numeric date/times to proper Date or POSIXct objects.

Value

A Date object if x is integer; a POSIXct object if x is numeric.

See Also

read_excel

Examples

  p_excel_dt( 40000 )
  p_excel_dt( c(40000,NA)) 
  p_excel_dt( Sys.Date() )
  p_excel_dt( Sys.time() )   
  
  p_excel_dt( c("12/1/2016 12:01 PM") )
  p_excel_dt( c("12/1/2016 12:01 PM", "12/1/2016", NA, "Unparsable", "4365") )
  

decisionpatterns/coercion documentation built on Nov. 4, 2019, 10:23 a.m.