Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Libre base: finding average of time

I'm very new to Libre base and trying to make a small database.

I have a Time field (HH:MM:SS) named Length that I need to do some calculations with. (In a query I want to find the average of all the times)

I know time is not a numeric and can't be added or subtracted. I been trying to find a tutorial online how to convert the HH:MM:SS to a decimal and than the decimal back to time but have failed. Is there a way to do what I'm thinking has to be done or a reliable reference how to do it?