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
Bookmarks