Solved: How to find the time difference between columns

Anonymous · ‎12-23-2020

Hi Everyone,

I have two columns which is a time format HH:MM:SS AM/PM. One is when the order was placed and second when the order was completed. I want to find out how long does it take to complete the order. Please advise.

Thanks.

PhilipTreacy · ‎12-23-2020

Hi @Anonymous

Subtract the start time from the end time.

TimeDiff = 'Times'[End] - 'Times'[Start]

Regards

Phil

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Blog :: YouTube Channel :: Connect on Linkedin

Proud to be a Super User!

View solution in original post

amitchandak · ‎12-23-2020

@Anonymous ,

Two way If you need time

Time = [Datetime2] -[Datetime1]

Diff in second= datediff([Datetime1],[Datetime2],second)

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube