calculate Hours Per Day

[jumiprado]

Hi to all!

I have the following table

ID	D.1	D.2	D.3	D.4	D.5	D.6	D.7	D.8	D.9	D.10	D.11	D.12	D.13	D.14	D.15	D.16	D.17	D.18	D.19	D.20	D.21	D.22	D.23	D.24	D.25	D.26	D.27	D.28	D.29	D.30	D.31
AAAA	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2.31	0	0	0	0	0
BBBB	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
CCCC	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
DDDD	9.50	14 F	0	0	8.05	8.00	7.21	9.33	7.18	0	0	0	0	8.02	7.59	8.28	0	0	8.07	8.09	9.03	8.17	9.31	0	0	6.59	14 F	9.20	0	0	0

Where i have for D.1 = DAY 1st of the month the worked hours per ID, and so on for the following days.

In some cases i have something like 14F or other alphanumerical code wich represents the reason for a day off.

I need to sum per MONTH the worked hours for each ID, and mark that days where someone takes a day off.

Thanks!

[sunny_talwar]

What is the expected output for the data you have provided?

[jumiprado]

Hi Sunny T, i need a table with ID, MONTH, Sum(Hours), Count(Days with alphanumeric codes).

The Information in the example is for one month but i have the same table for each month of the year so i need something like this

ID	Month	worked Hrs	Non Worked days
AAA	March 18	80	0
BBB	March 18	60	2
CCC	March 18	20	15

Thanks!

[sunny_talwar]

ID = CCC has all 0, how did you get worked Hrs = 20 AND Non Worked days = 15?

[jumiprado]

I tried to make an example with a resultant table, i need to separate the Hours values (4.25,8.5,7.0, etc) to (14F, 9B2, etc) and count or sum in that way.

Thanks!

[sunny_talwar]

May be like this

Count(If(IsNum(Value), Value))

or

Count({<Value = {"=IsNum(Value)"}>}Value)