Subtract 1 random no. in col from another without naming cells?

  • Thread starter Thread starter Chris Hughes
  • Start date Start date
C

Chris Hughes

Sorry if this has been covered elsewhere - couldn't think of of a search
keyword!

I'm working on rota. I've got a row for each hour, and a column for each
duty. In each column there are two numbers: a start time and a finish time.
But, of course, they won't be in the same rows.

I want to try out different possibilities and show the total time (start
time subtracted from finish time) under each column, without having to
specify the 2 cells every time I try a different arrangement.

Is there a way to do this? I should add that I'm not an expert coder, but
happy to cut and paste.
 
Hi Chris

Try the below formula which substracts the last entry from the first entry.
Adjust the defined range B2:B10 to suit your requirement.

=LOOKUP(10^10,B2:B10)-INDEX(B2:B10,MATCH(TRUE,INDEX(ISNUMBER(B2:B10),),))

'Format the formula cell to excel time format..

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need to subtract one cell from each cell in a row 1
add & subtract time in 1 formula 2
function returning SUM of 2 adjacent cols in 2 separate cells 7
Create a time-tracking sheet in Excel 1
How do I multiply ALL CELL in spreadsheet at once by .5 ? 4
Write formula for simple copy and paste to another cell 1
random numbers 5
Copy Data from 1 Sheet to Another 3

Back
Top