Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Date Difference

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  
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    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

     

     

v-robertq-msft's avatar
v-robertq-msft
Community Support
5 years ago

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.