sum time values

[Anonymous]

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.

[sasikanth]

hi,

can you explain a bit more what exactly you want to achieve?

if possible with a sample

[tamilarasu]

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')

[tresB]

Try like:

=Time(Sum(Time#(Field, 'hh.mm')), 'hh:mm')

[MarcoWedel]

‌Interval(Sum(field1)/24,'hh.mm')

[HirisH_V7]

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

[Anonymous]

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

[tresB · Accepted solution]

Wroking with me. Check attached qvw

[MarcoWedel]

Interval(Sum(Interval#(field1,'hh.mm')),'hh.mm')

[Anonymous]

thanks'

yarin