Calculate Duration from Specific Fields Using DQL

[goutham_a]

Calculate Duration from fields (StartTime and EndTime) and display the start date

Task	StartDate	EndDate	StartTime	EndTime
A	7/21/2025	7/21/2025	23:00:01	23:09:24
B	7/22/2025	7/22/2025	00:59:53	01:24:01

Need to calculate duration from 23:00:01 to 01:24:01 and display date as 7/21/2025 and duration.

[p_devulapalli]

@goutham_a You can try similar to below as an example

DQL data types

| fieldsAdd duration = (timeframe[end]) - (timeframe[start])
    | fields duration, timeframe[start]