Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have time filed
Time
1 AM to 2 PM
2 PM to 3 AM , 6 AM to 11 PM
4 AM to 6 AM
How to find the hr between AM and PM
Out put is
Hr Time
13 hr
18 hr
2 hr
Thanks advance.
Ram
=Interval(Time#(SubField(TimeField, ' to ', 2), 'hh TT')
- Time#(SubField(TimeField, ' to ', 1), 'hh TT'), 'h') & ' hr'
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
=Interval(Time#(SubField(TimeField, ' to ', 2), 'hh TT')
- Time#(SubField(TimeField, ' to ', 1), 'hh TT'), 'h') & ' hr'
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
Hi Rwuderlich,
Thanks for solution.
I got solution.
Thanks & Regards,
Ram