# 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

## AW:Converting hours to min

You want this?

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

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

## AW:Converting hours to min

You want this?

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

Highlighted
Valued Contributor

## Converting hours to min

Hi, this helps too

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

returns 770 = 12*60 + 50

Rgds

Highlighted
MVP

## Converting hours to min

Yet another way:

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