Why not just use

=D12-C12

and format as "hh:mm"

in the total box, format as [hh]:mm

--
HTH

Bob Phillips

"Coco" wrote in message
...
I am using =TEXT(D12-C12,"h:mm") to add the time between to times but I
can't
total the hours for the week. I use the function SUM(E10:E31) but it does
not work. I think it is because of the text format of the function that I
used above.

I appreciate anyone's help.

Thanks.