Totaling Hours in Standard Format
 

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.

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.

On Fri, 29 Jul 2005 09:35:05 -0700, "Coco"
wrote:

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.

Why not just use

=D12-C12

???


--ron

It does not work because I have the cells that's being calculated in time
formate so I had to formate the cell using the Text function in order for it
to calculate the diffence between the times.

"Bob Phillips" wrote:

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.

Have you actually tried it?

--
HTH

Bob Phillips

"Coco" wrote in message
...
It does not work because I have the cells that's being calculated in time
formate so I had to formate the cell using the Text function in order for
it
to calculate the diffence between the times.

"Bob Phillips" wrote:

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.