LO Base calculating times

English
#1

Is there a way in Base I can calculate the elapsed time between two fields stored as TIME; a StartTime and a FinishTime. If I try to run [FinishTime] - [StartTime] in my query, it appears to return a number that equals the elapsed seconds but I can’t seem to then format the result as HH:MM. Furthermore, if I try to divide the result by 1360, it seems to multiply instead of divide.

LibreOffice 6.1.3.2 Base on Windows 10 (x64)

What am I doing wrong?

image description
image description698×891 66.2 KB
(/upfiles/15422730283604126.jpg)

Attached screen grabs show the table structure and query results.

#2

It would help if you can show the query you are using, with the table structure against which you are querying. Edit your question to add the information, or use a comment.

#3

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.