Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

bibopipo
Contributor II

How to calculate minutes from hh:mm:ss

Hi,

is there a function to calculate from a time field like hh:mm:ss , the total minutes ?

I don't know how to do it

Help please

Thanks in advance for your help

3 Replies
pauljohansson
Contributor III

Re: How to calculate minutes from hh:mm:ss

Hi,

Maybe you can use the functions hour and minute?

Example:

LOAD * INLINE [
    time
    15:10:33]
;


load
hour((time))*60  + minute(time) as TotalMinutes
resident t_time;

br

Paul

bibopipo
Contributor II

Re: How to calculate minutes from hh:mm:ss

I've two time stamp fields and I calculate the duration by  Interval(FinalTime - Starttime) and I get the correct value in hh:mm:ss. Now I would transform the result in minutes, but I'm getting wrong values.

I tried by hour and minute without success.

nagaiank
Valued Contributor III

Re: How to calculate minutes from hh:mm:ss

Did you try the interval function as given below?

Interval(Time#(FinalTime,'hh:mm:ss') -Time#(StartTime,'hh:mm:ss'),'mm')

Community Browser