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.
CDateToUnoDateTime Function
Returns the time part of the date as a UNO com.sun.star.util.DateTime struct.