topic Convert the time into minutes in QlikView

Convert the time into minutes

jagannalla — Wed, 13 Apr 2011 07:14:13 GMT

Hi,

- I have a field with date and time( e.g 04-24-2011 1:24:56 ).

- Now i want to convert only time into minutes.

Is it possible to do this?

I want to do this b'coz. I need last 10 or 20 0r 30 mins in my report.

- Once i can able to convert the time into minutes. It is easy to reduce the minutes based on my selection of number of mins i need.

Convert the time into minutes

Wed, 13 Apr 2011 08:05:33 GMT

Ho Boppy,

simply cut the time from the whole value by using right() method. your time having 7 characters including :

let Totalminutes= subfield(right(FieldName,7),':',1) * 60 + subfield(right(FieldName,7),':',2) + subfield(right(FieldName,7),':',3) / 60

now your Totalminutes variable holding the total minutes..

Convert the time into minutes

Anonymous — Wed, 13 Apr 2011 08:23:41 GMT

Another approach to get the total amount of minutes would be:

=interval(frac(timestamp#('04-24-2011 11:24:56', 'MM-DD-YYYY h:mm:ss')),'mm')

Convert the time into minutes

jagannalla — Wed, 13 Apr 2011 10:43:21 GMT

Thanks for your response johannes sunden. But when i taken the field of particular date it is not working.

e.g:

=interval(frac(timestamp#('03-01-2011 1:24:14', 'MM-DD-YYYY h:mm:ss')),'mm')

replaced like this

=interval(frac(timestamp#(maxCarrdatetime, 'MM-DD-YYYY h:mm:ss')),'mm')

- I'm trying this to display in text box.

What is the problem? How can i overcome this? Plz help me

Re: Convert the time into minutes

Tue, 29 Apr 2014 14:31:12 GMT

You can try using

Interval(StartTime - EndTime) and then formatting this as interval on the number Tab, if you use the format mm , you would get the time difference in minutes

Re: Convert the time into minutes

Clever_Anjos — Tue, 29 Apr 2014 14:35:12 GMT

try

round(frac(yourfield),1/*(24/60))