@prefix skos: <http://www.w3.org/2004/02/skos/core#> .
@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix owl: <http://www.w3.org/2002/07/owl#> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
@prefix foaf: <http://xmlns.com/foaf/0.1/> .
@prefix mcr: <https://registry.apicrafter.io/vocab#> .
@prefix dt: <https://registry.apicrafter.io/datatype/> .
@prefix cat: <https://registry.apicrafter.io/category/> .
@prefix country: <https://registry.apicrafter.io/country/> .
@prefix tool: <https://registry.apicrafter.io/tool/> .

dt:excel_serial_datetime a skos:Concept ;
    skos:inScheme <https://registry.apicrafter.io/> ;
    skos:notation "excel_serial_datetime" ;
    skos:prefLabel "Date and time as an Excel serial number"@en ;
    skos:definition "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)."@en ;
    skos:prefLabel "Fecha y hora como número de serie de Excel"@es ;
    skos:broader dt:datetime ;
    skos:example "45175.42585648148" ;
    skos:example "31911.416666666668" ;
    skos:example "44927.5" ;
    mcr:status "draft" ;
    mcr:isPII false ;
    mcr:regexp "^[1-5]\\d{4}\\.\\d{1,17}$" ;
    rdfs:seeAlso <https://support.microsoft.com/en-us/office/datevalue-function-df8b07d4-7761-4a93-bc33-b7471bbff252> ;
    rdfs:seeAlso <https://en.wikipedia.org/wiki/Spreadsheet> .
