How to find the time difference between columns

[Anonymous]

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 · Accepted solution]

Hi @Anonymous 

Subtract the start time from the end time.

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

Regards

Phil

[amitchandak · Accepted solution]

@Anonymous ,

Two way If you need time

Time = [Datetime2] -[Datetime1]

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

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Subtract the start time from the end time.

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

Regards

Phil