Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i have feild that show time 1.36(1hour & 36 minute )
if i write in expression sum(feild1) the result is 5.44 (i have 4 line with that 1.36 )
how do i write to get the result in hour - 6.24 - 6 hour & 24 minute ?
thanks'
yarin.
Wroking with me. Check attached qvw
hi,
can you explain a bit more what exactly you want to achieve?
if possible with a sample
Try,
=Time(sum(Num(Time#(FieldName,'hh:mm'))),'hh:mm')
If your hour and minute format is 06.30 then try below,
=Time(sum(Num(Time#(F1,'hh.mm'))),'hh.mm')
Try like:
=Time(Sum(Time#(Field, 'hh.mm')), 'hh:mm')
Interval(Sum(field1)/24,'hh.mm')
Hi,
Check this with your time field,
=time(num(time#('00:20', 'hh:mm')) + num(time#('00:30', 'hh:mm')) , 'hh:mm')
So, it may look like this for you:
=time(sum(num(time#(TIME,'hh:mm'))),'hh:mm')
HTH,
-Hirish
hi,
i try all the answer and i didn't secceed .
exm:the feild look like this : 1.36
when i calcult sum ( for 4 lines ) i need to see 6.24
1.36 + 1.36 + 1.36 + 1.36 = 6 hour & 24 minute
Wroking with me. Check attached qvw
Interval(Sum(Interval#(field1,'hh.mm')),'hh.mm')
thanks'
yarin