Calculate total usage time

Get Help
1

HELLO !!!

I have read the following pages but I cannot find a good answer for my site:

I am working on an app for sailboats, a logbook where you can record all the navigations and maintain it.
On the home page I put a rectangle to see directly

  1. the total number of nautical miles traveled. Basic calculation is easy to set up. :joy:
  2. the total number of navigation times. Help me with this step please?

In the database, you can enter the date and time of departure and the date and time of arrival. and other information.
How to use this data to create “total browsing time”?

Sometimes we sail for a few hours and other times we sail for several days. I think it’s rewarding to see the experience gained directly on the home page of my app.

Then, I would have other calculation questions because I would like to integrate a countdown before the next engine oil change but we will see that in another post.

Thanks for help.

CapitaineYann

2

Even though it displays as a time and date, the date is stored in the database as a decimal number “x.y” with “x” being the number of days since 1 Jan 1970 and “y” the fraction of a day. So you can do normal arithmetic on it. So you just need to store the start and end date times you want and do a subtraction and then reformat the result as Hrs and minutes.

An alternative would be to send the dates to a make.com function that returns the result you need.