Calculate Duration from specific fields

[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 

https://docs.dynatrace.com/docs/shortlink/dql-data-types#duration

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