AM, PM time based find the hr difference

[Ramu_i]

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

[rwunderlich · Accepted solution]

=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

[Ramu_i]

Hi Rwuderlich,

Thanks for solution.

I got solution.

Thanks & Regards,

Ram