Forum Discussion

Foolke's avatar
Foolke
Helper I
6 years ago
Solved

Calculate time between 2 dates

All, all, all, all, I have several date/time columns. Start_date, Mid_date, End date. In power query I want to calculate how much time there is between e.g. Start_date& Mid_date, Mid_date & end_date...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Foolke 

     

    You can add a column like below.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Foolke 

 

Can you create a data sample?

Yes, the easiest way would be to add extra columns in PQ.

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

 

 

  • Foolke's avatar
    Foolke
    Helper I
    6 years ago

    Data sample

    TicketNrResolution_Actual_DateTimeBetweenSolved_Date
    INC-44599629/01/2020 9:43 29/01/2020 9:43
    INC-44748731/01/2020 15:23 31/01/2020 15:23
    INC-45578729/01/2020 9:15 29/01/2020 9:15
    INC-4626116/02/2020 21:30 6/02/2020 21:30
    INC-46632631/01/2020 11:58 31/01/2020 11:58
    INC-46662331/01/2020 13:03 31/01/2020 13:03
    INC-4720847/02/2020 12:40 7/02/2020 12:40
    • Mariusz's avatar
      Mariusz
      Community Champion
      6 years ago

      Hi Foolke 

       

      You can add a column like below.

       

      Best Regards,
      Mariusz

      If this post helps, then please consider Accepting it as the solution.

      Please feel free to connect with me.
      LinkedIn