Forum Discussion
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
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
2 Replies
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
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.
