Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
5 years ago
Solved

Calculate difference between two times? In HH:MM:SS

Hi all,   How do I calculate the difference between two time columns?   Both columns are in HH:MM:SS and I would like the difference column to be the same.     thanks,
Data Protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi HenryJS,

    Perhaps you can try to convert your time value to total second(numeric) then you can simply use math operator to calculate on converted values.

    For duration and time value transform, you can take a look at the following blog:

    Aggregating Duration Time 

    Regards,

    Xiaoxin Sheng

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi HenryJS 

In Power Query create a new Custom Column and subtract one from the other

#"Added Custom" = Table.AddColumn(#"Changed Type", "Difference", each [End]-[Start])

Phil 

HenryJS's avatar
HenryJS
Post Prodigy
5 years ago

PhilipTreacy  unfortunately the time columns are DAX columns