How do I calculate the total number of lag time of a given list?

[xycofryx]

Fabrik: 3.8.1
Joomla: 3.8.12

Background: I want to calculate the total number of lag time in years, months, days, hours, minutes, seconds in a given list. Is there a way I can insert it to the List View Settings -> Calculations -> Custom Calculations ?

 

[cheesegrits]

How is the lag time stored in the data? Is it a simple number (like seconds), or is it stored in that "X Min Y Sec" format?

If it's a simple seconds integer, then something like ...

TIME_FORMAT(SEC_TO_TIME(%x),'%i Min %s Sec')

... in the query might do it.

-- hugh

 

[xycofryx]

It is calc element so no storage... silly me I forgot to mention it

 

[cheesegrits]

Well, there will be storage, as long as the form for each row has been submitted. The calc element always stores the value on submit.

What I don't know is if the values are valid. If they are computed against two static dates (like a "start" and "end" on the form), then they will be. If they are computed against "now" (so time between a "start" date on the form and the date/time "now" when displayed), and you have "Calc on save only" set to No (so they recalc when you show the list), then no, the values in the table won't be valid.

So what is the actual calc doing?

-- hugh