topic minus between 2 time in QlikView

minus between 2 time

capriconuser — Wed, 23 Dec 2020 10:12:34 GMT

i have data like this

start_date due_Date completed_time_Date

I want to minus between times.. like if hours is greater than 59 minutes then consider as Hours and if hours is greater

then 24 then consider as day

I just want to minus startdate and completed_Time_Date and then compare respective result from due date time

what should I do

Taoufiq_Zarra — Wed, 23 Dec 2020 14:57:11 GMT

@capriconuser can you elaborate

you want completed_time_Date-start_date and result compare to to due_Date ?

can you share the expected output ?

capriconuser — Thu, 24 Dec 2020 04:57:52 GMT