topic Duration vs Time in App Development

Duration vs Time

Broly — Sat, 16 Nov 2024 01:39:41 GMT

Hello all,

can someone tell me how can I solve this issue?

As you can see on screenshot below, I have Arrival field and what I have issue with is the formating.

In the red square it is set to Time, and you can see that those values are correct, but SUM of those values is not, since it goes over 24 hours. In the green square, arrival field is set to duration, but you can see that values that have 00: in the beginning have their value increased with 24, which is not correct.

So basically I need format which will show correct data like in red square, but SUM should be able to show value like the value in the yellow square.

Re: Duration vs Time

Kushal_Chawda — Mon, 17 Aug 2020 11:42:04 GMT

you need to divide the value by 24 hour. try below

Sum(Duration)/24

Re: Duration vs Time

Broly — Mon, 17 Aug 2020 12:01:11 GMT

Hi,

I only get value divided by 24, so nothing happens.

Re: Duration vs Time

Kushal_Chawda — Mon, 17 Aug 2020 12:07:20 GMT

what is the expression you are using?

Re: Duration vs Time

Broly — Mon, 17 Aug 2020 12:40:26 GMT

Sum({$<AT_1_TIME_DIFF_CAT={">$(=0)"}>}AT_1_TIME_DIFF )
+
Sum({$<AT_2_TIME_DIFF_CAT={">$(=0)"}>}AT_2_TIME_DIFF )

Re: Duration vs Time

Kushal_Chawda — Mon, 17 Aug 2020 12:55:42 GMT

are the fields AT_1_TIME_DIFF & AT_2_TIME_DIFF contains hour values?

Re: Duration vs Time

Broly — Mon, 17 Aug 2020 13:27:44 GMT

Hi, they are in numeric format, and later formated into time. Should I try
something else?

Re: Duration vs Time

Usama — Mon, 17 Aug 2020 15:55:34 GMT

Hi,

Can you try this expression with Numeric format and then after that convert it into date format

Re: Duration vs Time

Broly — Tue, 01 Sep 2020 07:35:48 GMT

Hi all,

It appears that duration is correct.

I checked the data source and it is like it is shown in charts.

Sorry for the trouble, and thank you for answers.