Time difference calculation

[Deep]

Hello Dinesh,

You may refer to this old post with similar requirements

How to create a date out that shows days, hours, minutes, seconds

HI @jfant001 , Thanks for your query. Before going to create your calculated field as DD:HH:MI:SS you need to first create your date difference that is Call Start Time and Call End Time duration as sec. Step -1 dateDiff({Call Start Time},{Call End Time}, ‘SS’) Step - 2 Use this below formula [image] The yellow highlighted area is the field name of your date duration between start time & end time. Note - You can not plot this data on KPI visual type. If you want to Create DD:HH:MM:SS fo…

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

Hope this helps.

Cheers,
Deep