Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Time Difference in Power Query

Hi Experts   How would you calculate the difference in meeting start time and meeting end time in Power Query.  Sample Data   Start Time End Time 11:30:00   13:00:00 16:30:00   15:...
Need Help
  • vojtechsima's avatar
    vojtechsima
    4 years ago

    Anonymous 
    Add a new column like this:

     

    let
Difference = [End Time] - [Start Time],
Day = Number.Abs(Duration.Days(Difference)),
Hour =  Number.Abs(Duration.Hours(Difference)),
Minute =  Number.Abs(Duration.Minutes(Difference)),
Second =  Number.Abs(Duration.Seconds(Difference)),
FullDurationAbs = #duration(Day, Hour, Minute, Second),
NextDayDuration = #duration(0,24,0,0) - FullDurationAbs

in
if [Start Time] > [End Time] then NextDayDuration  else Difference

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

yes please

vojtechsima's avatar
vojtechsima
Super User
4 years ago

Anonymous 
Add a new column like this:

 

let
Difference = [End Time] - [Start Time],
Day = Number.Abs(Duration.Days(Difference)),
Hour =  Number.Abs(Duration.Hours(Difference)),
Minute =  Number.Abs(Duration.Minutes(Difference)),
Second =  Number.Abs(Duration.Seconds(Difference)),
FullDurationAbs = #duration(Day, Hour, Minute, Second),
NextDayDuration = #duration(0,24,0,0) - FullDurationAbs

in
if [Start Time] > [End Time] then NextDayDuration  else Difference