Please suggest me adding these hrs values in above coloumn
Hi,
With help of SUM formulas am unable to add total values with "h". In screenshot, in place of arrow mark i should get 75h(5h+10h+15h+20h+25h). please suggest how to accomplish this????
Best Answer

I would make a helper column between actual hours and estimated hours and add this formula and convert to column Formula
=VALUE(IF(LEN([Column2]@row) = 2, LEFT([Column2]@row, 1), IF(LEN([Column2]@row) = 3, LEFT([Column2]@row, 2)))
Of coarse Column2 would be your Column Header
Then in the cell that you have your arrow pointing to add this formula
=SUM([Column4]15:[Column4]17) + "H"
and Column4 would be the new column you made.
Let me know if this works
Answers

I would make a helper column between actual hours and estimated hours and add this formula and convert to column Formula
=VALUE(IF(LEN([Column2]@row) = 2, LEFT([Column2]@row, 1), IF(LEN([Column2]@row) = 3, LEFT([Column2]@row, 2)))
Of coarse Column2 would be your Column Header
Then in the cell that you have your arrow pointing to add this formula
=SUM([Column4]15:[Column4]17) + "H"
and Column4 would be the new column you made.
Let me know if this works

HI @Antonio Figueroa ,
Hope your are doing great!!!
Thanks for your time in writing me.
The formula you have suggested and the way you narrated was absolutely remarkable.
In my case, suggested formula perfectly working, Thanks.
Regards,
Rakesh.
Help Article Resources
Categories
Check out the Formula Handbook template!