For example, 12:00:00 corresponds to the date-time serial number 44235.5.

Internal to Calc, a date/time value is handled as a real number and this is sometimes referred to by the term date-time serial number.

If Text includes time components, they are ignored by DATEVALUE which only returns the integer part of the date-time serial number.Īdditional details: General information about Calc's Date and Time functionsįor convenience the information in this subsection is repeated on all pages that describe functions in the Date and Time category.This is because Calc handles the value in that cell as a number rather than a text string. If Text references a cell which contains a valid date expression and has its formatting set to Date, then DATEVALUE will return an invalid argument error (Err:502).If Text does not contain a valid date expression, then DATEVALUE reports an invalid argument error (Err:502).Text is a valid date expression, surrounded by quotation marks, or a reference to a cell containing a valid date expression formatted as a text string. Returns an integer value which is the date-time serial number corresponding to the date supplied as a text string argument. Converts a valid date expressed as a text string into a date-time serial number.

Err 502 openoffice