Just use =SUM(C1:C?)

where C? is the last cell with data that you want to include

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Andrew" wrote in message
...
I need each row to have its own total, and then have a total at the bottem
of
each column.

"Peo Sjoblom" wrote:

Maybe Andrew meant something like this in C2 so the values accumulate

=(B2-A2)*24+C1

and copy down

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Bob Phillips" wrote in message
...
As they are just decimal numbers now, they should simply add up. What
is
the
problem you get, give an example?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Andrew" wrote in message
...
I'm not sure what you mean, sorry...

"Gary''s Student" wrote:

Try formatting the sum as;

[h]:mm
--
Gary's Student


"Andrew" wrote:

I have created a formula for calculating total hours / day
the times are entered in military time
a1 = 7:30, b1 = 15:30, c1= =(b1-a1)*24, and it works great,
however I
can
not get those numbers in the C colum to add up for a rolling total

HELP !!!!!