Discussion Board for collaboration related to QlikView App Development.
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.
You want this?
= hour('12:50:00') * 60 + minute('12:50:00')
View solution in original post
SubField('12:50:00',':',1) *60 + SubField('12:50:00',':',2)
see the attached example.
I played arround a little bit with days, hours, minutes and so on.
Hi, this helps too
returns 770 = 12*60 + 50
Yet another way: