Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

Converting hours to min

Hi,

Is it possible to show convert hours into minutes by adding the minutes to it. Like if it is 12:50:00. I want to convert the 12hrs to minutes and add with the 50 minutes.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

AW:Converting hours to min

You want this?

= hour('12:50:00') * 60 + minute('12:50:00')


Vizlib Head of R&D

View solution in original post

5 Replies
Highlighted
Not applicable

Converting hours to min

use this

=



SubField('12:50:00',':',1) *60 + SubField('12:50:00',':',2)

SubField('12:50:00',':',1) *60 + SubField('12:50:00',':',2)





Highlighted
Not applicable

Converting hours to min

Hello again,

see the attached example.

I played arround a little bit with days, hours, minutes and so on.

Good luck!

Rainer

MVP & Luminary
MVP & Luminary

AW:Converting hours to min

You want this?

= hour('12:50:00') * 60 + minute('12:50:00')


Vizlib Head of R&D

View solution in original post

Highlighted
hector
Valued Contributor

Converting hours to min

Hi, this helps too


interval('12:50','m')


returns 770 = 12*60 + 50

Rgds

Highlighted
MVP
MVP

Converting hours to min

Yet another way:

interval#('12:50','hh:mm')*24*60