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