Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Kohli
Contributor

Convert the time stamp into minuits

I have time stamp field like HH:MMSmiley FrustratedS and convert it into Minuit's. Please suggest me.

Labels (1)
2 Replies
avkeep01
Valued Contributor

Re: Convert the time stamp into minuits

Hi @Kohli,

You can use *24*60 to get from timestamp to minutes. 

In this post you'll find more detailled information. 

https://community.qlik.com/t5/Qlik-Sense-App-Development/Aggr-Aggr-not-producing-expected-results-po...

 

MVP
MVP

Re: Convert the time stamp into minuits

Try like:

=interval(Time#('2:31', 'hh:mm'), 'm')

replace '2:31' with your time value.

Community Browser