---
id: "excel_serial_datetime"
kind: "pattern"
status: "draft"
is_pii: false
name: "Date and time as an Excel serial number"
regexp: "^[1-5]\\d{4}\\.\\d{1,17}$"
categories: ["datetime"]
langs: ["common"]
quality: 90
url: "https://registry.apicrafter.io/datatype/excel_serial_datetime"
---

# Date and time as an Excel serial number (`excel_serial_datetime`)

> **Draft.** Draft records have not been reviewed yet and may be incomplete or wrong; do not treat them as authoritative for legal or compliance decisions.

Point in time written as the serial number of spreadsheets: the whole part counts the days since 30 December 1899 and the fraction is the part of the day that has passed, as in 45175.42585648148 for 6 September 2023, 10:13:14, or 31911.416666666668 for 14 May 1987, 10:00. Sheets exported without a date format keep it: the Dataverse .tab export of an Excel file writes the timestamps of a survey or the readings of a gauge this way. A whole number is a date only (excel_serial_date).

- Pattern of: [`datetime`](https://registry.apicrafter.io/datatype/datetime.md)
- Personal data (PII): no
- Categories: Date and time (datetime)
- Countries: global
- Languages: Common to most languages (common)

## Detection

Regular expression (Python `re`):

```
^[1-5]\d{4}\.\d{1,17}$
```

## Examples

- `45175.42585648148` — 6 September 2023, 10:13:14, a survey response (datecreated, RDA-UNR)
- `31911.416666666668` — 14 May 1987, 10:00, a gauging at the Pavón stream (Fecha y Hora)
- `44927.5` — 1 January 2023, noon
- `45175` (invalid example) — a whole day: excel_serial_date

## Metacrafter rules

1 rules: 1 match the field name, 0 match values.

- `excelserialdatetimebyname` (field, `common/dateandtime.yaml`)

## Supported by tools

- [`metacrafter`](https://registry.apicrafter.io/tool/metacrafter.md)

## Translations

- es: Fecha y hora como número de serie de Excel

## Sources

- doc: <https://support.microsoft.com/en-us/office/datevalue-function-df8b07d4-7761-4a93-bc33-b7471bbff252>
- wikipedia: <https://en.wikipedia.org/wiki/Spreadsheet>

## Quality

Score 90/100. Missing: mapping (Wikidata, Schema.org, ...).

JSON: <https://registry.apicrafter.io/api/v1/datatypes/excel_serial_datetime.json> · Edit: <https://github.com/apicrafter/metacrafter-registry/edit/main/data/datatypes/any/datetime/excel_serial_datetime.yaml>
