Translations:Faq/Calc/139/3/en

    From The Document Foundation Wiki

    In both cases the value contained in the cell is in the format dd/mm/yyyy hh:mm:ss. The default format applied is dd/mm/yy for the date and hh:mm:ss for the time respectively, when only the chosen part is displayed.