# Formula to subtract two numbers in cell J6

1. ## Formula to subtract two numbers in cell J6

In cell J6 there are two numbers "280 - 321" , i need a formula to subtract those numbers, with the right number first subtracting the left number?

2. ## Re: Formula to subtract two numbers in cell J6

Hi Mr. Castle,

=MID(J6,FIND(" - ",J6)+2,LEN(J6))-LEFT(J6,FIND(" - ",J6)-1)

3. ## Re: Formula to subtract two numbers in cell J6

Are they always three digit numbers? If so, I could see using =RIGHT(J6,3)-LEFT(J6,3).

4. ## Re: Formula to subtract two numbers in cell J6

Jeff does this formula also works on time such as: "9:20 - 10:31"?

5. ## Re: Formula to subtract two numbers in cell J6

Not quite, but try...

=TRIM(MID(J11,FIND(" - ",J11)+2,LEN(J11)))-TRIM(LEFT(J11,FIND(" - ",J11)-1))

then format as h:mm

6. ## Re: Formula to subtract two numbers in cell J6

The formula worked,

Thank you Jeff

7. ## Re: Formula to subtract two numbers in cell J6

You are very welcome and thanks for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

8. ## Re: Formula to subtract two numbers in cell J6

You may need to add MOD function

Format as Custom, h:mm
Formula:
`Please Login or Register  to view this content.`

 v J K 6 9:20 - 10:30 1:10 7 9:20 - 10:37 1:17 8 9:25 - 05:45 20:20

##### Users Browsing this Thread

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

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