Difference between two dates

Hey guys.

I’m new to QuickSight and I have a question when calculating the difference between two dates.

I would like to obtain a field that can be calculated in HH:mm:ss when I make the difference between the end and start dates, as my ultimate goal is to calculate the average service time based on this difference between the dates. In that case, how do I do this?

image

Hi @JoaoCarvalho

Welcome to QuickSight community .

Please check the below DemoCentral dashboard for similar usecase to get the date difference in HH:MM:SS format .

https://democentral.learnquicksight.online/#Dashboard-TipsAndTricks-Calculation-Duration-Time-Format-HH-MM-SS-