topic Re: Count Work Hours in Search the Community

Count Work Hours

nuwanhwb87 — Mon, 26 Apr 2021 12:11:52 GMT

Hi All,

I have the below table with Fields of Date, Team, Hour 01, Hour 02, ....... up to Hour 13 . (Hour 01 Contains the Output of First hour)

As per the below i need to calculate the Worked Hours as 8. (Biggest Hour that works in a Day as the worked Hours)

(In the Middle Hr 05, Hr 06 likewise can be Zero due to Breakdowns and Etc)

Please Help.

Re: Count Work Hours

Saravanan_Desingh — Tue, 27 Apr 2021 02:43:42 GMT

Try this,

tab1: LOAD * INLINE [ Date, Team, Hr 01, Hr 02, Hr 03, Hr 04, Hr 05, Hr 06, Hr 07, Hr 08, Hr 09, Hr 10, Hr 11, Hr 12, Hr 13 4/22/2021, Team 41, 175, 230, 200, 230, 0, 0, 0, 170, 0, 0, 0, 0, 0 4/22/2021, Team 42, 175, 230, 200, 230, 0, 170, 0, 0, 0, 0, 0, 0, 0 4/22/2021, Team 43, 175, 230, 200, 230, 0, 0, 0, 170, 0, 0, 0, 0, 170 ]; Left Join(tab1) LOAD Date, Team, Pick(Match(-1,[Hr 13] > 0,[Hr 12] > 0,[Hr 11] > 0,[Hr 10] > 0,[Hr 09] > 0 ,[Hr 08] > 0,[Hr 07] > 0,[Hr 06] > 0,[Hr 05] > 0,[Hr 06] > 0 ,[Hr 05] > 0,[Hr 04] > 0,[Hr 03] > 0,[Hr 02] > 0,[Hr 09] > 0), 13,12,11,10,9,8,7,6,5,4,3,2,1) As [Hours Worked] Resident tab1;

Re: Count Work Hours

Saravanan_Desingh — Tue, 27 Apr 2021 02:44:09 GMT

Output: