topic Expression of time (today+1 - date) in App Development

Expression of time (today+1 - date)

Anonymous — Tue, 05 Jun 2018 10:58:34 GMT

Hi,

I would like ask for help with this example:

Calculation of time from today to start date (YYYY-MM-DD HH:MM:SS AM or PM). I get result in days like this ####.##############,

but I would like to have result like this : DDD:MM:SS (days, minutes, seconds).

Is it possible to do it in simple way e.g. getTime = (today+1 - date), DDD HH.MM.SS instead of decimal number in days

Thank

Svatava

jonathandienst — Tue, 05 Jun 2018 11:21:27 GMT

How about:

=Interval((today() + 1 - date), 'DDD:mm:ss')

=Interval((today() + 1 - date), 'd:m:ss')

jonathandienst — Tue, 05 Jun 2018 11:37:28 GMT

And if that does not work:

=Int(today() + 1 - date) & ':' & Floor(Frac(today() + 1 - date) * 1440) & ':' &

Mod(Floor(Frac(today() + 1 - date) * 86400), 60)

Anonymous — Tue, 05 Jun 2018 13:06:14 GMT

Hi,

=Interval((today() + 1 - date), 'd:m:ss')

It works perfect only I missed hours but this = Interval((today(2) + 1 - Opened), 'ddd hh:mm:ss') works perfect. Thanks

Br.

Svatava