sum total hours and minutes

ok I have read all the questions and answers and I still can't get my program
to work: here is what I do:
July Event StartTime End
Time

8 Purchase cat food / diet pepsi / rug cleaner 1:30 PM 2:15 PM 00:45
15 Pay house gas and phone bills 10:00 AM 10:30 AM 00:30

the format I use for start time is: TIME 1:30PM
the format I use for end time: TIME 2:15PM
the last column formula is: =TEXT(D4-C4,"hh:mm")
when I try to total that column for number of hours I keep getting 00:00
when I
should get 1:15 for 1 hour 15 minutes. CAN ANYONE HELP out on this please?
Thanks
Carson

"Carsonw8" <[email protected]> wrote in message
news:[email protected]...
> ok I have read all the questions and answers and I still can't get my
program
> to work: here is what I do:
> July Event StartTime End
> Time
>
> 8 Purchase cat food / diet pepsi / rug cleaner 1:30 PM 2:15 PM 00:45
> 15 Pay house gas and phone bills 10:00 AM 10:30 AM 00:30
>
> the format I use for start time is: TIME 1:30PM
> the format I use for end time: TIME 2:15PM
> the last column formula is: =TEXT(D4-C4,"hh:mm")
> when I try to total that column for number of hours I keep getting 00:00
> when I
> should get 1:15 for 1 hour 15 minutes. CAN ANYONE HELP out on this
please?

The column you are totalling is text, so the values will add up to zero.
If instead of =TEXT(D4-C4,"hh:mm") you just use =D4-C4 (and format it to
hh:mm), you should be OK.
--
David Biddulph

that was too easy! thanks...I was making it to hard for myself.

"David Biddulph" wrote:

> "Carsonw8" <[email protected]> wrote in message
> news:[email protected]...
> > ok I have read all the questions and answers and I still can't get my
> program
> > to work: here is what I do:
> > July Event StartTime End
> > Time
> >
> > 8 Purchase cat food / diet pepsi / rug cleaner 1:30 PM 2:15 PM 00:45
> > 15 Pay house gas and phone bills 10:00 AM 10:30 AM 00:30
> >
> > the format I use for start time is: TIME 1:30PM
> > the format I use for end time: TIME 2:15PM
> > the last column formula is: =TEXT(D4-C4,"hh:mm")
> > when I try to total that column for number of hours I keep getting 00:00
> > when I
> > should get 1:15 for 1 hour 15 minutes. CAN ANYONE HELP out on this
> please?
>
> The column you are totalling is text, so the values will add up to zero.
> If instead of =TEXT(D4-C4,"hh:mm") you just use =D4-C4 (and format it to
> hh:mm), you should be OK.
> --
> David Biddulph
>
>
>