Converting Time Values

The following functions convert time values to calculable numbers.

Hour Function

Returns the hour from a time value that is generated by the TimeSerial or the TimeValue function.

Minute Function

Returns the minute of the hour that corresponds to the serial time value that is generated by the TimeSerial or the TimeValue function.

Second Function

Returns an integer that represents the seconds of the serial time number that is generated by the TimeSerial or the TimeValue function.

TimeSerial Function

Calculates a serial time value for the specified hour, minute, and second parameters that are passed as numeric value. You can then use this value to calculate the difference between times.

TimeValue Function

Calculates a serial time value from the specified hour, minute, and second - parameters passed as strings - that represents the time in a single numeric value. This value can be used to calculate the difference between times.

CDateToUnoTime Function

Returns the time part of the date as a UNO com.sun.star.util.Time struct.

CDateFromUnoTime Function

Converts a UNO com.sun.star.util.Time struct to a Date value.

CDateToUnoDateTime Function

Returns the time part of the date as a UNO com.sun.star.util.DateTime struct.

CDateFromUnoDateTime Function

Converts a UNO com.sun.star.util.DateTime struct to a Date value.

Please support us!