Time span between two dates

Unknown

Time span between two dates

Unknown

Hello,
I have two date fields on my report. I want to get a time spam between those two dates in Hours and minutes? Is there a way to show a column on the report with this informaiton?

Unknown

We can add a calculated column field on the report that will display the time span for the two dates in hour and minutes.
To configure this we will need to add a field and expand the "calculated column category. here we can add the "get Hours Between" or "Get Minutes Between" fields.

[color=rgb(127, 140, 141)][font=Roboto][img]att2[/img][/font][/color]
Once the field is added we need to configure it. We will need to add the two dates that we need to get the time span for. click the field and navigate to the properties tab>Data section. Here we need to add the two dates. Note: These date fields also need to be added to the report.

[color=rgb(127, 140, 141)][font=Roboto][img]att3[/img][/font][/color]
Results would look like below.

[color=rgb(127, 140, 141)][font=Roboto][img]att1[/img][/font][/color]
[i]edited by faiza@decisions.com on 12/4/2020[/i]