Convert Min value into number

[#1]

Hi All,

I have a field in my report which is in min , (Calculated by using the interval function between two timestamp),.

Now i need to convert that value in to integer .

Time Difference(In Min)	Time To reduce	Expected Result
24	10	14
34	11	23
34	13	21

Thanks,

D J

[tresesco]

Minute to integer? you mean minute to hour? if so, then simply, = minute/60 .

[#3]

Time1	Time2	Time3	Interval(1,2)	Interval(2,3)	Coloumn(4)-Cloumn(4)
12/11/2013 12:20	12/11/2013 12:30	12/11/2013 12:10	10	20	10
12/11/2013 12:30	12/11/2013 12:50	12/11/2013 12:20	20	30	10
12/11/2013 12:50	12/11/2013 12:55	12/11/2013 12:30	5	25	20
12/11/2013 12:40	12/11/2013 12:50	12/11/2013 12:40	10	10	0

This was the exactly what I want , but instead of this I a getting some different vaues in Last coloumn.

Can any one kindly help me on this.

Thnaks

D J

[jonathandienst · Accepted solution]

Hi

If your minutes are displayed by Interval(TimeDiff, 'MM'), then multiply by 1440 (24 * 60) to get a value in minutes.

HTH

Jonathan

Edit:   eg (Time2 - Time1)*1440

[maxgro]

Hi

this is my result (see attachment)

Regards

[CELAMBARASAN]

Hi,

While using Interval, it still maintains internally a datetime/time format. Here you need conversion like

Minute(Column(5) - Column(4))

Interval(Column(5) - Column(4), 'm')