Count the value dynamically with condition

[SGK_TS]

Hello Team,

could you please help me on this below query .

I need to calculate number of working hrs dynamically from 9Am to 6Pm for each user with condition  (working hrs may change everyday ).If any user process <=3 system should ignore and calculate above >4 records only as per below then  i should get the output for actual number working hrs .

User	9AM	10AM	11AM	12PM	1PM	2PM	3PM	4PM	5PM	6PM	Count	Actual Working hrs -Output should be like this
123	8	16	3	15		10	2	55	14	3	9	6
456	6	44	4	18	12	0	6	62	15	44	10	9
789	4	62	4	0	13	12	4	4	16	23	10	9
125	2	32	4	20	14		32	23	17	2	9	7

[dwstada · Accepted solution]

@SGK_TS here is a workflow for your request :)

[flying008 · Accepted solution]

Hi, @SGK_TS 

FYI.

[SGK_TS]

Spoiler

Thank you so much it's working fine