Date interval

[#1]

suppose, I have a start date and a end date value. how do I get the duration by the interval function or if there is any other option?

example :

start time : 10:20:00 AM

end time :   2:20:00 PM

My desire output be like , Total hours : 4:00:00

Please help me.

[tamilarasu]

Hi,

try,

Expression:

Interval( Timestamp#([end time], 'hh:mm:ss tt') - Timestamp#([start time],'hh:mm:ss tt') , 'hh:mm:ss')

Load Script:

Load *,

Interval( Timestamp#([end time], 'hh:mm:ss tt') - Timestamp#([start time],'hh:mm:ss tt') , 'hh:mm:ss') as Interval

From Source;

[qlikvfpi]

Maybe like this :

=date(num(date('11:00','hh:mm'))-num(date('09:00','hh:mm')),'hh:mm')

[Chanty4u]

try this

am not sure

=Interval( Timestamp#([End Time], 'hh:mm:ss TT') - Timestamp#([Start Time],'hh:mm:ss TT') , 'hh:mm:ss')

[Kushal_Chawda]

=Time(frac(Time#([end time],'hh:mm:ss TT') -Time#([start time],'hh:mm:ss TT')),'hh:mm:ss')