LibreOffice 7.5 Help
Use the statements and functions described here to perform date and time calculations.
LibreOffice Basic lets you calculate time or date differences by converting the time and date values to continuous numeric values. After the difference is calculated, special functions are used to reconvert the values to the standard time or date formats.
You can combine date and time values into a single floating-decimal number. Dates are converted to integers, and times to decimal values. LibreOffice Basic also supports the variable type Date, which can contain a time specification consisting of both a date and time.