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