Please suggest me adding these hrs values in above coloumn

Rakesh Lavishetty

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????

colour.jpg

Antonio Figueroa

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

Antonio Figueroa

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

Rakesh Lavishetty

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.