Time Spent in One day

[jyothish8807]

Hi,

I want ot setup an formula for the mentioned scenario:

Suppose I have Four  coloum.

Name	Date	Time	Mode
a	1 July	8:00am	in
a	1 July	5:00pm	out
b	2 july	8:00 am	in
b	2 july	10:00am	out
b	2 july	10:15am	in
b	2 july	5:00pm	out

Now I want to find out the Whole time spent by the people for particular day .

Regards

Jyothish KC

[swuehl]

Please check the solution I proposed in this thread.

[Gysbert_Wassenaar]

Try something like:

interval(rangesum(sum({<Mode={'Out'}>}Time),-sum({<Mode={'In'}>}Time)),'hh:mm')

if your Time field contains strings instead of numeric times you'll have to make times of them first. This is best done in the script:

load

    Name,

    Date,

    time#(Time,'h:mmtt') as Timem

    Mode

from ...somewhere...;