Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
Did you try the interval function as given below?
Interval(Time#(FinalTime,'hh:mm:ss') -Time#(StartTime,'hh:mm:ss'),'mm')