Calculate time between "Begin Date & Time" and "End Date & Time" fields

[Former user]

Hi, we're trying to add a JWT field that could calculate time between "Begin Date & Time" and "End Date & Time", and present it in days then hours then minutes if possible.

Can you help us with the proper expression for that?

[Fidel Castro Armario]

Hi @amishenin_ha,

You can use a "Calculated Number Field" with the following configuration:

Math-Time expression is:

{bbbbb} != null AND {eeeee} != null ? {eeeee} - {bbbbb} : null

replacing bbbbb with field code for Begin Date & Time, and eeeee with field code for End Date & Time.

[Former user]

Works very well. Thanks for your quick and detailed response Fidel!