Totaling Hours in Standard Format

Why not just use

=D12-C12

and format as "hh:mm"

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

--
HTH

Bob Phillips

"Coco" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]>
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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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.
> > >
> >
> >
> >

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]>
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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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.
> > >
> >
> >
> >