Sum of hours and minutes over 1000hrs and converting to week days

Hi,
Please help to get a appropriate formula to sum below hours, I am getting the total as 537:11:27 (shown in A6) if I use =sum(A1:A5),

• Need formula to sum these hours

• Convert to weekdays considering only Mon-Fri (5days in a week), expecting in this format 5w 2d

Provide these two formula by considering that i am going to use in two cells.

Column	h:mm
A1	1101:58
A2	2.59
A3	2003:11
A4	19.41
A5	0.39
A6 (Total)	537:11:27

Please post a sample sheet so we can see real formatting

Hi Chinto..

Can you please check by changing below two formula..
In E7 instead of =INT(((Calculation!N24+Calculation!N48)*0.02)/60)&":"&MOD(((Calculation!N24+Calculation!N48)*0.02),60)

check with Below formula..

Formula:

Please Login or Register  to view this content.

and in E9, instead of =INT(((Calculation!N24+Calculation!N48)*0.15)/60)&":"&MOD(((Calculation!N24+Calculation!N48)*0.15),60) this formula check with below..

Formula:

Please Login or Register  to view this content.

Format the cell as required..

Now.. hope your SUM formula is working..

Above both formula returning TEXT.. not possible to use in SUM