This sample app shows how you can calculate cumulative duty hours with one click.

I tried to click on the Google icon to sign in but couldnâ€™t, for some reason. Is there a way to open this in a separate window?

Some kind ofâ€¦ why not.

Hi Aleksi! How are you?

If I trigger the â€śINâ€ť 2 hours latter I click â€śOUTâ€ť, and a couple of days latter I make the same trigger process.

Does the function SUM the time of 2 days or it just sum the actual time between triggers no matter how many days are between INÂ´s and OUTÂ´s?

It should calculate durations between IN & OUT, not OUT & IN.

Ok.

Another question, how can show a CONCATENATE format that shows Hours, minutes and seconds?

Hi Aleksi!

How could I get a 00:00:00 hour format from this formula? : IF([IN OR OUT]=â€śPAUSAâ€ť,LOOKUP([_THISROW].[ID],Comentarios, ID,IN)+TOTALHOURS([TIMESTAMP]-LOOKUP([_THISROW].[ID],Comentarios, ID,TIMESTAMP)),

LOOKUP([_THISROW].[ID],Comentarios, ID,IN))

Hi, may I ask what is the result now?

Hi!

The result is Decimal 0.0603

And you want to convert the decimal to hour format as 00:03:37?

Yes thatÂ´s correct!

How can I do that?

Do you want to calculate seconds as well?

If itÂ´s posible yes.

Try something likeâ€¦

```
RIGHT("0"&FLOOR([Decimal]),2)&":"&
RIGHT("0"&FLOOR(0.6*MOD([Decimal]*100,100)),2)&":"&
RIGHT("0"&ROUND(0.6*MOD(60*MOD([Decimal]*100,100),100)),2)
```

Thanks Aleksi!

Youâ€™re welcome

Hey Aleksi!

Another question.

I need to take this kind of time mesure for 12 different users in the same table, but I need to calcualte the time for each of thouse users.

I can duplicate the amount of columns of the â€ścronoâ€ť logic for the amount of users 12, but that I think it would be a lot of columns. Is there a way to do it without duplicate the amount of columns so I can take the time for each user?

Also, what happens if the â€ścronoâ€ť reach 99:59:59, is going to grow on houndreds of hours? 100:00:00

If one user has his own record, why donâ€™t you calculate it with a normal column so it will calculate it when the decimal is added?