topic How To Convert Time into Mins? in QlikView

How To Convert Time into Mins?

jagannalla — Wed, 13 Apr 2011 12:15:28 GMT

Hi,

- I have a field wtih Date and time in my script.

- Now i want to convert the time into minutes and should stored in variable.

- I tried the following script in the text box. It is working perfecty and display in the text box.

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

But it is not working when i taken the field of particular time(i.e DateTime)

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

Plz help me...

stephencredmond — Wed, 13 Apr 2011 12:21:54 GMT

Hi,

Date and time values are stored as the number of days since 30/12/1899 + fraction of a day. So, if the fraction is .5, that would equal 12 noon.

If you subtract Date - Floor(Date), you will get that fraction and then you can multiply by (24*60) to get the number of minutes.

Regards,

Stephen

jagannalla — Wed, 13 Apr 2011 12:32:26 GMT

Hi Stephen,

I didn't get you what your are saying can you explain briefly........

Wed, 13 Apr 2011 12:44:03 GMT

Have a look at the attached application.

Logic in the attached application is what Stephen Redmond talking about.

- Sridhar