Results 1 to 7 of 7

Sum cells after applying a formula

Threaded View

  1. #1
    Registered User
    Join Date
    05-05-2010
    Location
    Rotterdam, Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    22

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1