# How to calculate duty hours in one day with one click

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

5 Likes

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?

Open the app directly from www.appsheet.com/portfolio/531778. App name is â€śIn Dutyâ€ť

1 Like

@Aleksi We could use this also for a Stopwatch

1 Like

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)
``````
3 Likes

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?