Worked hours

[#1]

Hi,

I have the same problem as some other have had here in the community but I can't get the suggested solutions to work. I want to calculate the number of hours worked each day. It works just fine if they have clocked in and out ONCE a day. But when someone clocks in and out more than ONCE, it breaks.

Please see attached file. I have selected an employee that has clocked in twice ion the 7th of January. I would like the calculation to be presented in the pivot chart on the left called "CALCULATION".

Thanks in advance - I'm thankful for suggestions!

[tamilarasu]

Hi Daniel,

Check the attachment.

Clock In Expression:

Time(Min(ReportingTimeIn),'hh:mm:ss')

Clock Out Expression:

Time(Max(ReportingTimeOut),'hh:mm:ss')

[jagan]

Hi,

Just use

Clock In =Max(ReportingTimeIn)

Clock Out= Max(ReportingTimeOut)

and in Number tab select Time for this two expressions.

Hope this helps you.

Regards,

Jagan.

[HirisH_V7]

Hi,

Check this,

In Time
Time(Aggr(Min(ReportingTimeIn),prv.Person,ReportingDate),'hh:mm:ss') 

Out Time
Time(Aggr(Max(ReportingTimeOut),prv.Person,ReportingDate),'hh:mm:ss')

Time Reported
TIME([Clock out]-[Clock in],'hh:mm:ss')

Hope this helps,

Regards,

PFA,

Hirish

[#5]

Hi, Thanks for you response.

Doing it as you describe, I will get a summary from start time to end time. If a person clocks in and out for the first time

06:49:00

16:05:00

09:16:00

and then clock in for the second time:

19:52:00

20:45:00

00:53:00

The aggregated time will be 10:09 hours/min and not 13:56 as I understands your solution shows.

Any ideas in how to fix it?

Thanks in advance.

Daniel

[jagan]

Hi,

Calculate the difference of TimeOUt and Timein in script and just sum up the difference in the chart.

Hope this helps you.

Regards,

jagan.

[#7]

Hi,

I think I already do that, but it shows the wrong summary as I mentioned aboove.

    if(AttRRepType=3, Time("AttrRepDt_Time"),null()) as ReportingTimeOut,

    if(AttRRepType=1, Time("AttrRepDt_Time"),null()) as ReportingTimeIn,