Create a Formula When there are gaps.

  • Thread starter Thread starter Growing
  • Start date Start date
G

Growing

:)
Hello All. I joined the group this morning.

I have a spreadsheet where I am calculating Runtimes.

Job Name Date Start Time End Time Run Time
ABCDEFG 9/27/2005 1:11:55 1:59:21
0:47

Start and End Times are in cells G and H, BUT the cell # changes o
each row. I am typing this formula for each row: =H(some #) - G(some#
=Run time.

Is there a way I can calculate the Run time w/out entering the abov
formula for each line?

Thanks In Advance

P.S. Also when the spreadsheet begins a new Job Name, there will be
blank row
 
You can copy the formula down the column by dragging the fill handle (black
square in lower right of active cell) or by double clicking it if the cell
is the last column in a table.
 
Back
Top