Forum Discussion
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:00:00 | |
| 09:15:00 | 10:30:00 |
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
5 Replies
Hi, Anonymous
simply like this:Anonymous
Because Start Time is bigger than End Time, do you want me to recreate and check if the Start Time is bigger, it takes the time to another day? so it would 22,5 hours?