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?
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?
Hi Mr. Castle,
How about...
=MID(J6,FIND(" - ",J6)+2,LEN(J6))-LEFT(J6,FIND(" - ",J6)-1)
HTH
Regards, Jeff
Are they always three digit numbers? If so, I could see using =RIGHT(J6,3)-LEFT(J6,3).
Originally Posted by shg
Jeff does this formula also works on time such as: "9:20 - 10:31"?
Not quite, but try...
=TRIM(MID(J11,FIND(" - ",J11)+2,LEN(J11)))-TRIM(LEFT(J11,FIND(" - ",J11)-1))
then format as h:mm
The formula worked,
Thank you Jeff
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.
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
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks