Forum Discussion

MarcusR1's avatar
MarcusR1
Icon for Helper II rankHelper II
2 years ago
Solved

Time calculation and formating in Power BI

Hi, I have some time related data including start, stop and duration (in seconds) and I want to display a summary card with the hours:minutes:seconds but I can't seem to get the formula to work:   ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    MarcusR1 Should just be:

     

    Duration = [end] - [start]

DurationFormatted = FORMAT([duration], "hh:mm:ss")

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

MarcusR1 Should just be:

 

Duration = [end] - [start]

DurationFormatted = FORMAT([duration], "hh:mm:ss")

 

  • MarcusR1's avatar
    MarcusR1
    Icon for Helper II rankHelper II
    2 years ago

    Thank you Greg, that's great. How do I sum those to get: