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

     

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