Time difference calculation

[tdr_Dinesh]

Hello Team,

I would like to calculate the time difference between the start date and end date. I have written the following formula:

Datediff(endtime, starttime)

Using this formula, we get the difference between the dates, but we need the output in HH:MM:SS format.

Any assistance will be greatly helpful.

[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