sum total hours and minutes

[Guest]

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

 

[David Biddulph]

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.

 

[Guest]

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