I have the following text populated in an Excel cell:
Task 1 (3 hrs); Task 2 (4 hrs); Task 3 (1 hr)

I need to calculate the sum of (3+4+1) = 8 hrs and populate this in another cell.