How to add and subtract time in Power BI

[LC0804]

Hello to all,

I would like to know if it's possible to display time (format hh:nn:ss) in a matrix or a table under Power BI desktop.

Indeed, when I add in a table or a matrix my column "Average duration" in the format "Hour" as quoted previously I can't make any calculation and the totals displayed automatically in the matrix indicates me only the smallest or the longest duration.

I would like to know if it's then also possible to calculate average times or even add and subtract them by keeping them in hh:nn:ss format

Thank you in advance for your answers.

[DOLEARY85]

Hi,

you can add or subtract time to a date column using calculated column and the TIME function e.g:

Column = 'Table (6)'[Date]+TIME(1,0,0)  - adds 1 hour

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍