Help Calculate duration of hours

[EvertonGS89]

I need to calculate the difference between this time so when I do the calculation the result is this could you help me

,,Tempo = DATEDIFF('f-_PRINCIPAL'[Hora Inicio],'f-_PRINCIPAL'[Hora Fim], SECOND)

But the result is that

[EvertonGS89]

Thank you!

[OwenAuger · Accepted solution]

Hi @EvertonGS89 

Since the columns Data Inicio & Data Fim contain datetime values, you should be able to reference them instead to get the expected difference in seconds:

Tempo =
DATEDIFF ( 'f-_PRINCIPAL'[Data Inicio], 'f-_PRINCIPAL'[Data Fim], SECOND )

Does this work for you?