Republican date and decimal time support in libreoffice

This is a wiki page. Be bold and improve it!

If you have any questions about the content on this page, don't hesitate to open a new ticket and we'll do our best to assist you.

Libreoffice does not support at all the Republican calendar.

Use this page to document ways to support decimal time and the republican calendar in Libreoffice.

Decimal time

Fortunately, converting from and to decimal time is easy in Libreoffice.

Internally, Libreoffice saves times as a decimal number, with 1 being the value corresponding to a whole day, i.e. 24 hours.
If you have a field HH formatted as a time (24 hour clock), then you can have another field formatted as a number NN.
To convert 24 hour times to decimal time, use the formula: NN = HH * 10.
To convert a decimal time to 24 hour time, use the formula: HH = NN / 10.

See also