topic Re: subtract times with AM and PM values in QlikView

subtract times with AM and PM values

Mon, 07 Dec 2015 19:43:00 GMT

Hi all.

I have a csv file with two different columns:

START END

8:00 AM 9:00 AM

10:15 AM 12:00 M

I need to calculate the time difference in hours and minutes.

I tried:

interval(END]-[START], 'hh:mm')

And nothing happens. I think that the time fields are not well format, so I tried again:

Interval(Time#([END],'hh:mm') - Time#([START],'hh:mm'),'hh:mm')

And again, doesn't work.

Suggestions?

sunny_talwar — Mon, 07 Dec 2015 20:07:24 GMT

Try this:

Interval(Time#([END],'hh:mm TT') - Time#([START],'hh:mm TT'),'hh:mm')

javier_florian — Mon, 07 Dec 2015 20:08:58 GMT

Hi Chang,

You would use the follow formula:

=Time(Your_Field,'TT')

maxgro — Mon, 07 Dec 2015 20:10:45 GMT

you just miss the tt

have a look at format code in QlikView help

Examples (Time):

hh:mm describes the time as 18:30

hh.mm.ss.ff describes the time as 18.30.00.00

hh:mm:tt describes the time as 06:30:pm

Mon, 07 Dec 2015 20:12:42 GMT

Thanks it worked!

sunny_talwar — Mon, 07 Dec 2015 20:17:04 GMT

Hahahaha mine worked but the correct answer is going to maxgro .

JK. I am glad we were able to help.

Best,

Sunny

Mon, 07 Dec 2015 20:22:58 GMT

Sorry with the documentation reference of maxgro i also solved other questions.

You rocks Sunny!

sunny_talwar — Mon, 07 Dec 2015 20:44:29 GMT