Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
Maybe like this :
=date(num(date('11:00','hh:mm'))-num(date('09:00','hh:mm')),'hh:mm')
try this
am not sure
=Interval( Timestamp#([End Time], 'hh:mm:ss TT') - Timestamp#([Start Time],'hh:mm:ss TT') , 'hh:mm:ss')
=Time(frac(Time#([end time],'hh:mm:ss TT') -Time#([start time],'hh:mm:ss TT')),'hh:mm:ss')