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 complete the order. Please advise.

 

Thanks.

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)

2 Replies

  • 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

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous ,

    Two way If you need time

    Time = [Datetime2] -[Datetime1]

     

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