Help calculating time until

Wappler General Need Help
1

Hi please could one of you whizz kids help me out
I have 4 fields in my database all logging time
time1, time2, time3, time4
I can get the number of hours and mins between time1 and time4 and also time2 and time3 which is exactly what i need, however I need to addone result to the other and display the result
I need to work out and display the following
{{time1.timeUntil(time2, true)}} + {{time3.timeUntil(time4, true)}}
this outputs something like this 00:00:0300:00:03
but I need it to output 00:00:06

Is this possible or am I barking up the wrong tree

2

Hi, try this expression:

{{time1.timeUntil(time2, true)}} -- {{time3.timeUntil(time4, true)}}

or

{{time1.timeUntil(time2, true) -- time3.timeUntil(time4, true)}}
3

thanks for the reply sorry i meant add not subtract (i will edit my post)
{{time1.timeUntil(time2, true)}} ++ {{time3.timeUntil(time4, true)}}
I get the following output
00:00:03 – 00:00:03
and
{{time1.timeUntil(time2, true) ++ time3.timeUntil(time4, true)}}
00:00:0300:00:03

it should be 00:00:06
not sure what im doing wrong

4

If u use – it will add not subtract :slightly_smiling_face: its double - - but together.

5

Thanks for taking the time to help Max_Saravia
However I tried it and i get the following outputs
00:00:03 – 00:00:03
and
NaN

6

If I do
{{time1.secondsUntil(time2, true)}} – {{time3.secondsUntil(time4, true)}}
or minutesUntil or hoursUntil
It gives me the correct answer,
it just does not work with timeUntil

However I need to output the full time HH:mm:ss