topic Re: Add Hour and minutes in QlikView

Add Hour and minutes

sum25041994 — Wed, 05 Apr 2017 05:27:03 GMT

Hi,

How to add Hours and minutes and display total minutes in a listbox:

ex: 02:30:00 should be 150 minutes

05:30:00 should be 330 minutes

08:00:00 should be 480 minutes.

Regards,

Sumit

Re: Add Hour and minutes

Anil_Babu_Samineni — Wed, 05 Apr 2017 05:39:18 GMT

May be this in script

Interval(Time#('02:30:00','hh:mm:ss'),'mm')

And change FieldName instead of static in script and then call that attribute

Re: Add Hour and minutes

Anil_Babu_Samineni — Wed, 05 Apr 2017 05:42:09 GMT

For you

LOAD Hrmnts, Interval(Time#(Hrmnts,'hh:mm:ss'),'mm') as Hours Inline [

Hrmnts

02:30:00

05:30:00

08:00:00

];

Output this?

Re: Add Hour and minutes

sum25041994 — Wed, 05 Apr 2017 05:42:40 GMT

Hi Anil,

Thanks for the help. But i have a lot of time field, is their any shortcut method in script side that help me.

Regards,

Sumit

Re: Add Hour and minutes

Anil_Babu_Samineni — Wed, 05 Apr 2017 05:44:23 GMT

Have you seen my second reply, that is the best way and easy

Re: Add Hour and minutes

rahulpawarb — Wed, 05 Apr 2017 05:54:13 GMT

Hello Sumit,

Trust that you are doing good!

Please refer given sample script:

Data:
LOAD *,
     (Hour(Time#(T_Time, 'hh:mm:ss TT')) * 60)
     + Minute(Time#(T_Time, 'hh:mm:ss TT')) AS T_NewTime;
LOAD * INLINE [
T_Time
02:30:00 AM
05:30:00 PM
08:00:00 AM
12:45:00 AM
12:45:00 PM
];

Also refer the sample application attached herewith.

Regards!

Rahul

Re: Add Hour and minutes

Anonymous — Wed, 05 Apr 2017 06:13:20 GMT

Hi ,

This would help in frontend-

if((Minute('Timefield')+hour('Timefield')*60)>=720,0,Minute('Timefield')+hour('Timefield')*60)

Example

=if((Minute('5:30')+hour('5:30')*60)>=720,0,Minute('5:30')+hour('5:30')*60)

330 min

Thanks

Paridhi

Re: Add Hour and minutes

sum25041994 — Wed, 05 Apr 2017 06:24:42 GMT

Hi Paridhi,

Thanks for the reply, it's working, but total minutes which is greater then 720 is showing 0.

Need your help on this.

Regards,

Sumit

Re: Add Hour and minutes

sum25041994 — Wed, 05 Apr 2017 06:28:15 GMT

Hi Rahul,

Thanks for the response, it's working , but can i know what's the requirement of T_time inside load table

LOAD * INLINE [
T_Time
02:30:00 AM
05:30:00 PM

it's creating an extra irrelevant value in my listbox. if i am removing that one in script, it's showing error.

Need your help on this

Regards,

Sumit

Re: Add Hour and minutes

Anonymous — Wed, 05 Apr 2017 06:36:28 GMT

Hi Sumit,

I just put the condition of 12 hours if you dnt need it ,

=Minute('5:30')+hour('5:30')*60)

Just apply this

Thanks

Paridhi

Re: Add Hour and minutes

rahulpawarb — Wed, 05 Apr 2017 06:39:01 GMT

Hello Sumit,

Field T_Time is from base table which holds the Time values in original format. However, if you need it then you can keep it or else you can drop/do not mention the same (refer below script).

Data:  
LOAD 
     (Hour(Time#(T_Time, 'hh:mm:ss TT')) * 60)  
     + Minute(Time#(T_Time, 'hh:mm:ss TT')) AS T_NewTime;  
LOAD * INLINE [  
T_Time  
02:30:00 AM  
05:30:00 PM  
08:00:00 AM  
12:45:00 AM  
12:45:00 PM  
];

Hope this will be of help.

Regards!

Rahul

Re: Add Hour and minutes

sum25041994 — Wed, 05 Apr 2017 07:02:48 GMT

Thanks Paridhi. it's working

Re: Add Hour and minutes

sum25041994 — Wed, 05 Apr 2017 07:03:12 GMT

Thanks Rahul

Re: Add Hour and minutes

rahulpawarb — Wed, 05 Apr 2017 07:05:20 GMT

Cheers,

Rahul

Re: Add Hour and minutes

luiferva — Fri, 03 Jun 2022 16:44:52 GMT

Hola, una posible solución que encontre y lo puedes hacer en expresiones del grafico de esta manera

Hour('02:37:30 AM')*60 + Minute('02:30:30 AM')

Resultado