Forum Discussion

kenblack's avatar
kenblack
Icon for Helper I rankHelper I
6 years ago
Solved

calculating duration

I have two columns both in the following format   04/06/2020 05:02:00 so dd/mm/yyyy hh/mm/ss and I would like to subtract one from the other to get the duration in hrs - can anyone help please   ...
Tips and Tricks
  • edhans's avatar
    edhans
    6 years ago

    Use the Duration.TotalHours() function in Power Query. Just subtract column 1 from column 2. It will return total and fractional hours.

    If you just need hours, round it using Number.Round(formula, 0) 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

kenblack ,

[Date1]-[date2] will give duarion

datediff([Date1],[Date2], hour) will give diff in hours