We have a spreadsheet to keep track of pump runtimes.

We want the run times in column B to be subtracted, with the result being sent to column C as, for example, B4-B5. 3 to C4. Simple formulas like =B4-B5 in C4 and subsequent columns don't bother me. However, I want B7 to omit B8 and B9 and instead deduct B10 when I arrive to B8. Because it was a weekend on the 25th and 26th, no values were recorded. What, if any, would be a formula I could apply (since these sheets are produced, recorded on the spot, and then sent back to the facility at the end of the month)?

Dec 24, 2022 in Others 480 views

## 1 answer to this question.

Try the following formula in C4 and drag down

`=IF(B4<>0,B4-INDEX(B5:\$B\$33,MATCH(TRUE,B5:\$B\$33<>0,0)),0)`
• 63,420 points

## How to automatically assign a color to the maximum and minimum values in a set of selected cells in Excel?

See Conditional Formatting, which may be accessed ...READ MORE

## How to merge two cells in excel with same field name

Insert 2 new columns, G & H. Enter ...READ MORE

## In Excel, how to find a average from selected cells

If one has the dynamic array formula ...READ MORE

## How to add Conditional Formatting in Excel for a Range of Values

Three distinct rules are required, one for ...READ MORE

## Return blank cell only if referred cell is blank, but return aging if date is entered

Try this: =IF(ISBLANK(AC2),"",TODAY()-AC2) The TODAY  function automatically refreshes based ...READ MORE

## Is there a maximum number of formula fields allowed in Excel (2010)

See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate ...READ MORE

## Multiplying cells and sum then for a range

Use SUM() as an Array formula:  =SUM(IFERROR((AB22:AB1100 = ...READ MORE

## How to lock data in excel sheet using POI, leaving cells without any data / the rest of the sheet unlocked

If the cells in a row have ...READ MORE

## How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE