Sum cells after applying a formula

Hello everybody,

Probably really basic but this is not working for me.

I have a column (A) which has two elements in each cell, the # (number) of bookings and the total amount of hours.
Each cell looks like this:

(1) 4.00
(5) 3.33
(19) 54.50
(30) 75.25

I wanted to separate the two values and I manage to do it (probably in a really complicated way, but it works).
After transformation everything looks like this:

original	#	Time (h)
(1) 4.00	(1)	 4.00
(5) 3.33	(5)	 3.33
(19) 54.50	(19)	 54.50
(30) 75.25	(30)	 75.25

The formulas used were:

=IF(ISTEXT(A2),LEFT(A2,SEARCH(")",A2)),"")
=IF(ISTEXT(A2),RIGHT(A2,LEN(A2)-SEARCH(")",A2)),"")

My problem now is that the total amount of hours is not recognized as number and I can not make basic functions like sum on these cells.
Could anyone look at this and let me know how I can solve it?

The attached file has an example where you can work on.

Thank you all in advance,
Joćo

Whoooaaa...

Works perfectly. Can you explain me the rationale behind it?
Also, is there any other way to do it without changing the formulas (that will be a pain for my entire workbook). Maybe on the cell properties?

Cheers

And how would I change the formula to accept the cells as numbers?

I played really quickly now and I know if I do =SUM(--B3) this will transform that cell into a number. But If I use =SUM(--B3:B5) this will give an error.
If there is no other way I guess I will have to change the formulas across the workbook.

Cheers and thanks again.

Thank you both for the help.

I'll add the tag Solved.

Cheers