I know that, but t does not work
a b c
1 7:30 17:30 10.00
2 7:30 17:30 10.00
3 7:30 10:30 3.00
4 7:15 17:30 10.25
5 7:15 17:30 10.25
#VALUE!
Formula for c3 is =(b1-a1)*24
hope ths helps
"Peo Sjoblom" wrote:
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 !!!!!