topic Re: How round a time to the nearest minute? in App Development

How round a time to the nearest minute?

Hans_K — Mon, 29 Jan 2024 07:25:56 GMT

I have the following expression: Interval(Sum(uren)/24, 'h:mm:ss')

The value of Sum(uren) = 38,75

The result of my expression = 38:44:59

How do get the following result?: 38:45 (rounded to the nearest minute)

ManuelRühl — Mon, 29 Jan 2024 08:20:10 GMT

38,75 should return exactly 38:45.

Maybe this works: Interval( ROUND( Sum(uren) , 0.01 ) /24, 'h:mm:ss')

Hans_K — Mon, 29 Jan 2024 09:01:21 GMT

Thanks Mruehl. But the result is stil 38:44:59.

Pierrick — Mon, 29 Jan 2024 09:08:26 GMT

try this : Interval(Sum(uren)/24, 'h:mm')

Or change the format of your measure in the vizualisation for Duration and change 'h:mm~~:ss~~'

mikaelsc — Mon, 29 Jan 2024 09:18:09 GMT

round your result to the nearest minute?

Interval(round(Sum(uren)/24,1/(24*60)), 'h:mm')

"interval()" is just a formatting function..

Hans_K — Mon, 29 Jan 2024 10:00:24 GMT

Thanks Pierrick, but still 38:44.

Enno86 — Mon, 29 Jan 2024 10:10:34 GMT

I think you need to use "ceil" as a function, in order to round to next higher minute.

Hans_K — Mon, 29 Jan 2024 10:12:02 GMT

Thanks Mikaelsc!

The 3th column result is now 38:45. My next challenge is the total-value, that's still 38:44.

Hans_K — Mon, 29 Jan 2024 10:14:18 GMT

Thanks Enno86.

It's not the next higher minute. It's the nearest minute. If it's 38:44:29 it should be 38:44.

Enno86 — Mon, 29 Jan 2024 10:22:59 GMT

Hans_K — Mon, 29 Jan 2024 11:39:07 GMT

Thanks Enno86, i did. But it was not the solution for me.