Date Difference

[Anonymous]

Hello, 

is it possible to subtract the 2 columns below and get the answer in a time format. 

The format that I am looking for would be 

7:14:41 or just 7:14

[v-robertq-msft]

Hi, @Anonymous 

According to your description and sample data, I can clearly understand your requirement, you can try this calculated column to output the duration time in the correct format:

Duration =

var _diff=[Date2]-[Date1]

return

HOUR(_diff)&":"&MINUTE(_diff)&":"&SECOND(_diff)

And you can get what you want, like this:

You can download my test pbix file below

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat · Accepted solution]

In the query editor, add your column where you subtract the two columns, which will result in a duration.  Change the type to a decimal number (that will be in days).  Load the data, then go to the Diagram View and use a custom format string to display it as a datetime with a format string of hh:nn:ss

Pat