How to calculate minutes from hh:mm:ss

[Anonymous]

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

[pauljohansson]

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

[Anonymous]

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]

Did you try the interval function as given below?

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