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