sum (expression)

[Anonymous]

sum(interval(INTime-VLateTime,'hh:mm'))

it shows error in calculation

[er_mohit]

sum(Interval(time(INTime,'hh:mm')-Time(VLateTime,'hh:mm'),'hh:mm')

[Anonymous]

no its not working

[Anonymous]

I suspect there should be aggr within sum:

sum(aggr(interval(...)), something)

Can't tell for sure without seeing an example.

Regards,

Michael

[Anonymous]

this is sample file pls see that table box has error in calculation.....

[er_mohit]

m using personal edition so can't open your file.......

tell me the exact expression where you get the eror

[Anonymous]

I don't see error here, it returns some result.  Anyway, see if this is what you expect:

=interval(aggr(sum(INTime-VLateTime),ID), 'hh:mm')

Edit: In fact, I think that your expression is correct, the one without sum.  Actually it depennds on what is the purpose of this calculation

=Interval (INTime-VLateTime,'hh:mm')

[Anonymous]

i need to calulate the  total late hours for each and every person

[er_mohit]

aggr(Interval(time(OUT_TIME,'hh:mm:ss')-Time(IN_TIME,'hh:mm:ss'),'hh:mm'),person)

change with your fieldname it gives you total hours

[Anonymous]

if i click the department i need to show the department wise late hours...if i click particular person it show the person late hours...