Formula To Subtract Pounds & Ounces

Jun 29, 2009

I need to build a spreadsheet that subtracts from a cumulative weight recorded in pounds and ounces. For example, in a fishing tournament, a person has 5 fish to weigh. They place their fish one at a time in a bag hanging from a digital scale that reads in pounds and ounces, and record the cumulative weight as the fish are added. We want to know what the total weight is of all 5 fish, but also what the individual weight is of each of the 5 fish.

The easy way to do it is to place the first fish in the bag and record the weight, then place the second fish in the bag with the first fish and record the cumulative weight of the 2 fish together. Continue this until all 5 fish are in the bag, and record the final total weight.

Then, to get the weights of each individual fish, the first weight is as it is, the second fish weight would be Cumulative Weight recorded for Fish 2 minus the weight of Fish 1. To get the weight of Fish 3, you would subtract the Cumulative Weight for the first 3 fish from the Cumulative Weight of the first 2 fish, and so on.

For example:

Weight of the Bag with:
1 Fish: 1-lb 2-oz
2 Fish: 2-lb 14-oz
3 Fish: 5-lb 6-oz
4 Fish: 9-lb 7-oz
5 Fish: 11-lb 9-oz.

We can subtract the cumulative weights to determine the individual weights of each fish added to the bag and know that:

Fish 1 is 1-lb 2-oz
Fish 2 is 1-lb 12-oz
Fish 3 is 2-lb 8-oz
Fish 4 is 4-lb 1-oz
Fish 5 is 2-lb 2-oz

Easy to do in my head, or on paper, but not so easy to do in Excel because it's pounds and ounces, which is how the digital scale reads out. But, when you're doing this for 20-30 fishermen, it's not that easy to do it on paper.

View 9 Replies


ADVERTISEMENT

Sum Of Pounds And Ounces For Fishing Tournament

Jan 7, 2009

I need a spreadsheet to calculate the sum of pounds and ounces. Example
3 fish caught weighing 5lb 8oz plus 3lb 8oz plus 2lb 8 oz = 11lb 8Oz.

This calculation is when the weigher has a scale that measures in OZ.
I also need a spreadsheet that will take a scale that measures in 10ths to add lb and 10th and give a result in lb and oz?

View 9 Replies View Related

Add Sum Of Lbs And Ounces For Shipping / Packing List Purposes?

May 16, 2013

I am looking to sum the weight I add in my packing list spreadsheet.

below are two ways i have been working with and will settle with what ever i can get. all i need is to be able to enter the weight of a package either by lbs.oz or in separate columns (lbs)(oz) then have a formula take either way and know there is only 16 oz in a lb and give me a total weight of all things shipped.

.lbs
.oz
5

[Code]....

View 1 Replies View Related

Using GBP And Pounds / Shillings As Currencies?

Dec 29, 2010

I am creating a simple spreadsheet to catalog some magazines. One of the columns shows the cover price which is okay for post 1970 magazines as it is in Pounds Sterling, but is there anyway I can get Excel to recognize Pounds/Shillings/Pence as currency. So put in "8d" for example without setting the field to a text format?

I want to be able to add up the total cost of some items based on their cover price but if I set the required cells to text format I cannot do this automatically using the Sum forumla.

Is it possible to have both Pounds Sterling and Pounds/Sillings/Pence as currencies in the same table or is using a text field for the latter the only option?

View 2 Replies View Related

Converting Euros To Pounds

Jan 27, 2010

I have a large spreadsheet that I need to convert the euros amount to the equivalant in pounds in various places throughout the spreadsheet.

View 9 Replies View Related

Formula For Subtract I62 From I62 Only If F62 Contains P/UT?

Dec 28, 2013

I need a formula to do the following

Subtract I62 from I62 only if F62 contains P/UT and put answer of subtraction in L62.

Cells are in Time format

View 8 Replies View Related

Pounds To Kg Separation In Combined Data

Aug 19, 2013

I receive a monthly spreadsheet from our trucking company which tracks the package and weight of that package. However I need to pull the weight out and run a report on total weight. However it is a mix of pounds and kilograms. Please see my example. What I want is a final column of all weight converted to kilograms. Note as well the spacing in the data as sometimes the "lbs" is right next to the number and other times there is a space between them.

Raw Data

package 1
10.2kgs

package 2
5 kgs

[Code] ........

View 3 Replies View Related

Converting From Kilos To Stones And Pounds

Jul 19, 2007

I'm trying to write a spreadsheet that compares body weights for older people in the UK who are not at ease with metric figures. I've searched the board and have come up with several answers, but they don't seem to work for me.

For instance, cell A1 is kilos, and I'd like that weight in stones and pounds in cell A2. What I've come up with for cell A2 is this:

=ROUND((A1*2.2046)/14,)&"st " &ROUND(MOD((A1*2.2046),14),0)&"lbs"

This works for, let's say, 90.8kgs in A1 (answer: 14st 4lbs), but if I enter 87.6kgs, for example, I get an answer of 14st 11lbs. I think it's something to do with the "ROUND" function but I'm struggling. Any help would be much appreciated. Thanks.

By the way, for non-Imperial weight people, multiplying by 2.2046 converts kilos to pounds, and there are 14 pounds (lbs) in a stone.

View 9 Replies View Related

Subtract Some Data With Formula

Nov 15, 2012

I have travel data for hundreds of cars. Col A has the car ID number. Col B has the date. Col C has the distance of a journey. Column D, has the total distance traveled on a given date for a given car.

In Column E, I'm trying to calculate the remaining distance to travel "prior" to the journey being made.

I a have attached an example. [URL] ....

So in column E, prior to the first journey (9km) being made there is 19 km still to travel in the data. And for the second journey the is 10 km left to travel.

View 1 Replies View Related

Formula To Subtract A Number Per Day

Aug 5, 2009

I needa formular that will subtract a number per day, for example as one day passes you can set the amount of number to be taken away from the total.

View 12 Replies View Related

Formula To Subtract A Value From A Cell

Oct 26, 2008

I need a formula that will subtract a value entered in A3 from a valued entered in A2 to be displayed in A1.

Also...the Value displayed in A1 must be the value of A2 minus the running total in A3.

Ex...If I type '10' in A2 and type '3' in A3 the value shown in A1 must equal '7'. If I then type '2' in A3 the new value in A1 must equal '5' (this being the value in A2 of '3+2' minus from the original value in A2 of 10)

So..A2 = inputted value , A3 running total of inputed value, A1 differnce of A3 from A2.

Is this even possible? The whole idea is this....if you type a number into a calculator, and then subtract a number from the first number, the calculator then displays the new total. If you then subtract an number from that NEW total, the calculator then displays that NEW total. Thats what I'm trying to re-create in excel.

View 9 Replies View Related

Formula: Subtract The Values

Dec 1, 2009

Need a formula that will subtract the values in X:Z subtracting the lowest value from the second lowest, then using that value and subtract from the 3 value. The outcome will always be positive and range from 0-9. Expected results are in Col AA. Then I need an adaption of that formula to read a 3-digit value in one cell.

******** ******************** ************************************************************************>Microsoft Excel - CASH 3 MID MOSTLY.xlsx___Running: 12.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutW1=WXYZAA111/30/094774211/29/099636311/28/091632411/27/097687511/26/095775611/25/097801711/24/093003811/23/097700911/22/0952851011/21/0990361111/20/09346512 13 1411/22/095285 1511/21/099036 1611/20/093465 Sheet2 [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name boxPLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

View 9 Replies View Related

X= Formula; Subtract The Number From Cell C32

Mar 19, 2007

in Cell J32 I want it so when i type in a number it would subtract the number from Cell C32. Is there a formula in which all you have to do is type the number without editing the formula?

View 3 Replies View Related

Formula To Add Row Of Numbers And Then Subtract If From Another Cell Amount

Dec 1, 2013

I have a row A through N. In cell A1, have a dollar amount. In cells C1 through N1, I have different dollar amounts. In cell O1, I want to have a formula that will take the dollar figure in A1 and subtract from that amount the total of all the amounts in cells C1 thorugh N1. But I don't know how to write that formula.

Let's say I've got $100 in A1, and then in C1 through N1, I have $2, $3, $4, etc. for a total amount of $94 in cells C1 through N1. I'd like to have a formula in O1 that would show $6.

How to write up that formula in cell O1.

View 1 Replies View Related

Formula That I Can Add, Subtract, Divide, Average, Etc, Etc These Numbers

Jun 19, 2008

Imagine I have cells A1 to A5 with a sequence of "numbers" like this:

A1 = 50-55
A2 = 45-67
A3 = 56-90
A4 = 49-80
A5 = 51-55

The left hand side numbers represent a score a minus sign (-) to separate and the right hand side represent another score. I want a formula that I can add, subtract, divide, average, etc, etc these numbers.

If I want to add the left hand scores, for example, cells A1 to A3, sum would be 151 (50 + 45 + 56).

View 9 Replies View Related

Formula To Subtract Invoices From Total Amount Available

Sep 25, 2009

I have 2 tables, one with invoices, the other with purchase orders. I would like to have a "PO Amount Remaining" column on the invoice table that looks up the PO listed on the invoice with the PO $ amount on the PO table. Once it is matched, I would like to subtract the total invoices to give me the amount of the PO that is left. Basically I would like the "PO Amount Remaining" column right now to have $4,200 listed in each row for invoices 1 & 2.....

View 18 Replies View Related

Can Split Currency Into Two Separate Columns Showing Pounds And Pence?

Dec 1, 2012

I have a mileage expenses form from work that I am trying to fill in using Excel, instead of filling it in by hand.

Column R shows the miles travelled.

Column S shows the Rate per Mile.

Column T (should) show the pounds.

Column U (should) show the pence.

Searching has led to T11, for example, using the formula below to show the pound value.

Code:
=INT(R11*(S11/100))

However, I am having less luck on finding a way to display the pence amount in U11.

Ideally, I would like the cells in column U to show the pence without a leading zero or decimal point and just the pence value only.

View 7 Replies View Related

Match/Index Formula :: Multiply Last 3 Cells In A Row And Subtract 1

Sep 23, 2009

I am having a little trouble with multiplying a few formulas. I am looking for a formula that will multiply the last three cells in a row that contain data and subtract 1. Below is an example of the type of data I am working with and the formula I am trying to use but is not working. The formula is for the cell highlighted in red. Every quarter the last three cells being referenced will change.....

View 9 Replies View Related

Subtract Amount From Cell Until It Reaches 0 Then Move And Subtract From Next Amount?

Apr 28, 2012

I am trying to subtract an amount from a cell until it reaches 0, then move and subtract from the next amount, and so on.

AmountFixed BudgetedResult53.50Subtracted 5 tell it hit zero1.30Subtracted remaining amount until zero43.8Subtracted remaining amount until zero3.8 was left over without hitting zero is good. Is there formula for this?

View 6 Replies View Related

Excel 2013 :: Formula To Subtract 7th Column Values From Column Before 1st Loop?

Feb 21, 2014

I have a code that inserts a new column after every 7th column. I want to include a formula where every 7th column value is subtracted from the values present in the column before the 1st, or you can think of it as subtracting 7th column of the present group from the 7th column of the previous group. Example: The range of my data starts from col F, then

F (7th) New Column (G) H (1st) I (2nd) J (3rd) K (4th) L (5th) M (6th) N (7th) New Column (O) P (1st) Q (2nd) R (3rd)

So, New Column (O) = N - F
and the next New Column (W) = V-N ...

NOTE: Column G can be ignored.

I want to add a looping function to this so that it will continue to subtract for the other respective columns as well. How do I incorporate this into the following code?

[Code].....

I'm using Excel 2013.

View 2 Replies View Related

Subtract From Inventory

Jan 28, 2008

Firstly i am running Excel 2003 (at work)

Now my problem is that i have been asked to make a spreadsheet about Printer and Fax Cartridges (Zzzzz) but i do not know how to do the sum.

this is how my Spreadsheet looks like this (cartidge amount etc all on top line of spreadsheet)
(Hp45 etc all down left hand side) ...

View 9 Replies View Related

Subtract Dates D:hh:mm

Oct 24, 2008

Seems that when I subtract a future date from NOW() and format the cell d:hh:mm that the result is 1 day off. So if I subtract NOW() (today is 10/24) from 10/25/08 it returns a 1 for the d when I would expect it to be zero.

View 14 Replies View Related

Subtract The Dates.

Apr 13, 2009

I have 2 cells in a row that are times, it has been a while since I did any work in excel. I want to take the first cell as start Time, the second cell is end time and I need to subtract them and put the total in a cell called Hours. What is the correct format to use and how would I do the subtraction.

Generally start time will be AM and End Time will be PM.

View 8 Replies View Related

Add And Subtract Time

Jun 1, 2009

How do I add and subtract hours minutes and seconds?

I’m writing a program to find when the sun is directly overhead. I’m doing this so that I can find the true north/south line. In the example on my program, at the town of Farmington, a plumb bob will cast a shadow on the north/south line at 11:51:39 on June 16

View 9 Replies View Related

If? Vlookup? (take The Value And Subtract It)

Dec 30, 2009

Cell D10 to be a formula that; Looks at Cells E13:E38 and if in this range the text "Sick" appears looks at the adjacent cell H13:H38 (which has a numeric value). It will then take that value and subtract it from D8.

I will have to do this for 2 other text strings as well, Vacation and Holiday.

View 2 Replies View Related

Add Or Subtract From Total

Feb 20, 2010

CELL A1=45

I want CELL A2 to be a blank cell which people can enter a number in that will decrease the value of A1 and once that value is entered, it would return to a blank cell. CELL A3 would be used in the same fashion except to increase the value of A1

what would a formula for this look like?

View 10 Replies View Related

Subtract From Two Cells?

Jun 23, 2014

im trying to subtract from two cells. see below

i have two cells, lets say A1 which has number 10 in it, and cell B1 which has -1 in it, but when i use this formula in cell C3 =sum(A1 - B1) It add it on when there's a minus sign in front of the number is there a way around this?

View 2 Replies View Related

Subtract But With Positive Sum

Dec 6, 2006

Im working on a time schedule form for my work. It all works good but it have one little error.

Lets say it looks like this
cell a1 has start time 22:00 and a2 has a end time 07:00. i know that i can switch the cells in the formula =sum((a1-a2)*24). like this i´ll get a negativ answer and that f.cks up the totalt becuse of the negativ answer i get.

is there a way to get 7:00 - 22:00 and 22:00 - 7:00 to calculate as positiv with one formula?

View 9 Replies View Related

Subtract Dates

Apr 23, 2007

I have a column with start date and another next to it with end date. I now want a third column that gives the number of days alloted. I tried

=G6-F6 and that didn't work. What should I do?

View 9 Replies View Related

Subtract The Time

Dec 1, 2007

I need to be able to determine a departure time based on: Appointment - Transit time - 1 hour buffer......Clear as mud?

I tried using =SUM(M2-N2)-1, but being a noob, it's not working and I am lost, yes I admit it, I'm lost...

I do have all the cells format set [h]:mm

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved