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.