Round Duration up to the next full hour

[Michael_at_Graz]

Hello Everybody.

I have the following Situation:

I use an app for the timemanagement for my employees and from the timestamp [Begin] and [Ende] i got the Duration [Stunden] of there working time. So now, in Austria, we pay money for traveling employees. We pay this for every next beginning our. 

I explain:

John worked 7:35 on monday, so i have to pay for 8:00 Hours.

Everything in my app work well, but i dont know, how to tell appsheet, that he has to round the Column [Stunden] up to the next full our, and not the column [Stunden] itself, cause this would get the wrong Duration of there work, but in the following formel, where i use the Column [Stunden] it should round it up, bevor calculating:

IF(
AND(
[Stunden]>"03:00",
[_THISROW].[Zähler]<13)
,
([Mitarbeiter].[Diäten]/12)*Hour([Stunden])
,
(([Mitarbeiter].[Diäten]-12)/12)*Hour([Stunden])
)

has anyone a idea, how to fix this?

Many thanks in advance for your reply and nice greets from Austria

[Marc_Dillon]

https://www.googlecloudcommunity.com/gc/forums/searchpage/tab/message?filter=location&q=round%20time...

[Michael_at_Graz · Accepted solution]

Many thanks for your help.

I found the easiest way with just adding 0:59 to column [Stunden]:

IF(
AND(
totalhours([Stunden]) > 2,
[_THISROW].[Zähler] < 13)
,
(26.40/12) * hour( [Stunden] + "000:59:00" )
,
(14.40/12) * hour( [Stunden] + "000:59:00" )
)

Hope it helps someone.