Calculate Difference on Time

[SH30]

Hi All,

Is there a way to calculate difference between 2 times to show for example how many days between the first and second value?

The image below provides the results and ideally I'd have another column that calculated that difference, just not sure what the operator would be to calculate that (can always remove the time portion to just get how many days it is).

[#2 · Accepted solution]

You could try this approach:

datatable (Date1:datetime, Date2:datetime)

[

datetime(2018-06-11 10:05:00), datetime(2018-06-11 11:05:00),

datetime(2018-06-11 10:05:00), datetime(2018-06-12 11:05:00),

datetime(2018-06-11 10:05:00), datetime(2018-06-13 14:05:00),

datetime(2018-06-11 10:05:00), datetime(2018-06-15 09:05:00)

]

| project Diff=format_timespan(Date2-Date1,"d"), Date1, Date2

[#3]

Exactly what I was looking for, much appreciated!