Totaling Hours in Standard Format

[Guest]

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.

 

[Bob Phillips]

Why not just use

=D12-C12

and format as "hh:mm"

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

 

[Ron Rosenfeld]

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

 

[Guest]

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.

Why not just use

=D12-C12

and format as "hh:mm"

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

--
HTH

Bob Phillips

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.

 

[Bob Phillips]

Have you actually tried it?

--
HTH

Bob Phillips

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.

Why not just use

=D12-C12

and format as "hh:mm"

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

--
HTH

Bob Phillips

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.