formula help

Hi all, I was wondering if there was a formula so that I could convert the following into the desired format. <colgroup><col></colgroup><tbody> 12 mins 52 secs = 12.52 4 mins 11 secs = 4.11 23 mins 35 secs = 23.35 2 mins 39 secs =2.39 29 secs =0.29 22 mins 33 secs =22.33...

Hoping someone can help me with this one. I've tried the COUNTIF and the IF methods I could think of and I can't figure how to make a simple formula I can put into the cells of a column that will do the following: Consider that Column E needs to contain a list of dates. 1. I need a formula...

E4 = Dark Stone Grey - (Part ID: 4210977) I want D4 to be Dark Stone Grey

Hello, I will try to explain you how I want my formula to be in English language IF cell B101 containts "Tuesday" then (B103-B102)+(B105-B104)+(B107-B106)... My original idea is something like this, but I don't think it's possible, so the above is enough help for me...

In a spreadsheet I have a column of dates (column r). I have a formula in a cell =INDEX($R$4:$R$57, MATCH(MIN(ABS($R$4:$R$57-$H$7)), ABS($R$4:$R$57-$H$7), 0)) Which is looking for the nearest date in column r (my list) to the date in H7. This has been working fine but I now need to tweak...

<tbody> Name Start Time Old Start Time New Change Within 4 hrs? Jeff 9:30 AM 10:30 AM Yes Walter 10:00 AM 9:30 AM Yes Sam 1:00 PM 8:00 AM NO Theodore 12:00 PM 7:00 AM NO Brandt 2:00 PM 12:00 PM YES </tbody> Hello and thanks in advance for your help. I'm...

I am running windows-7 and using Excel 2007 in Microsoft Enterprise. I am a truck driver and I have not been able to get any help on this workbook problem. I have been over this before with someone else who thought he could help but couldn’t. I gathered all the information that he asked for and...

Hi, I have this formula: <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> =SUM(IF(NOT(ISERROR(--(TRIM(SUBSTITUTE(LOWER($B$6:$O$62),LOWER(MID(N2,1,SEARCH("...

Hello, I have a column ("REFERENCE") which is intended to display row numbers in order (ie. 1, 2, 3, 4, etc...). I would like to write a formula that returns the value of the cell above +1. The column contains a number of hidden rows throughout the range and I would like the formula to look for...

Hi, I have a data series running horizontally, which gives me monthly values e.g. Jan - £10 Feb £12 Mar £11 etc. Imagine the months are in row 2 beginning from column 2, and the values are in column 3. I would like a formula which adds the three values, and in row 6 column two gives me the...

Hello, I am trying to use this formula: =IF(AND(C753>=10/01/2012,C753<=12/31/2012),"Qtr 1",AND(C753>=01/01/2013,C753<=3/31/2013),"Qtr 2",AND(C753>=04/01/2013,C753<=06/30/2013),"Qtr 3",AND(C753>=07/01/2013,C753<=09/30/2013),"Qtr 4","N/A") I know that the "AND"s are screwing everything up, but...

I am trying to create a formula that will return a record number (in column A on "Report" sheet) based on matching both a last name (C4) and date (E4) with a corresponding last name (column AE) and date (column B) on a second sheet ("Report"). This is what I have so far...

I wander if you can help with the below: I have an ingredient list on a sheet <tbody> INGREDIENT PACKAGE SIZE COST SERVING SIZE PER CONTAINER TOTAL COST PER UNIT cereal hoops (3 x 586 box) 1.53 kg £11.89 1 tablespoon 102 102 £0.12 tablespoon marshmallows 500 grams £2.99 1 corn 30...

I am using this formula in excel 2010, "=IF(ISBLANK(P7),"",IF(P7<0,Q7="0",IF(H7>0,H7-P7)/0.25),IF(I7>P7-I7)/0.25)))" which is not being accepted and displays a message "too many arguments for this function" with only the last section 0.25 highlighted...

Am having issues with this function, does anyone know of any issues with it? Thanks =SUMPRODUCT(--($B$4:$B$67<=2),--($B$4:$B$67>5.01),--($D$4:$D$67))

I need a formula that will do this: 1. I have a list of 8 codes. 2. The list may contain duplicates. What I need is a formula in 8 cells of another list that is based on the initial list. 1. It is also 8 cells of data. 2. The data will contain each code from the initial list but only one time...

Please help if possible. I do appreciate. I will attempt to explain as best I can. Column L is my High Watermark (HWM) Values. Cell L4 contains a pre-determined value and the formula for Column L begins in L5. Column L formula is: =SUM(L4+D5-E5-G5-H5-I5-J5+K5) and this formula is copied for...

<TABLE style="WIDTH: 433pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=577><COLGROUP><COL style="WIDTH: 30pt; mso-width-source: userset; mso-width-alt: 1462" width=40><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1865" width=51><COL style="WIDTH...

Hi everyone i need help with creating a formula in the following instance..:confused: If value of cell in the range of E2 through to E17 is between 100 and 139 then +1 in K2 but i also need the '1' in K2 to remain even after the values in E2-E17 have been deleted and if another value in the...

Hi I am building a timesheet and I have become a bit stuck. I have already got the timesheet to automatically calculate the number of hours once the start time and end time are entered(these cells are all in hh:mm format). The column which calculates the total time is AA4. Then I have the...