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" wrote in message
... 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" wrote in message ... 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 |
All times are GMT +1. The time now is 02:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com