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 !!!!!