Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Try this:
Interval(Time#([END],'hh:mm TT') - Time#([START],'hh:mm TT'),'hh:mm')
Hi Chang,
You would use the follow formula:
=Time(Your_Field,'TT')
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
Thanks it worked!
Hahahaha mine worked but the correct answer is going to maxgro .
JK. I am glad we were able to help.
Best,
Sunny
Sorry with the documentation reference of maxgro i also solved other questions.
You rocks Sunny!