Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to find the time difference between columns

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 comple...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi Anonymous 

    Subtract the start time from the end time.

     

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

     

    Regards

    Phil

  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous ,

    Two way If you need time

    Time = [Datetime2] -[Datetime1]

     

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

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
5 years ago

Hi Anonymous 

Subtract the start time from the end time.

 

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

 

Regards

Phil