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?
Open the app directly from www.appsheet.com/portfolio/531778. App name is “In Duty”
@Aleksi We could use this also for a Stopwatch
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.
Another question, how can show a CONCATENATE format that shows Hours, minutes and seconds?
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)),
Hi, may I ask what is the result now?
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)
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?