use custom format [hh]:mm


On Dec 8, 1:15*pm, JoRDaN wrote:
I am trying to add these times and it keeps giving me 23:55 for total hours. *
i know this is wrong can some one help me?
column a * column b * column c
7:30 PM 9:30 PM 2:00
8:45 PM 5:30 AM 8:45
8:15 PM 1:10 AM 4:55
8:15 PM 2:00 AM 5:45
8:15 PM 2:00 AM 5:45
8:15 PM 4:30 AM 8:15
8:15 PM 2:00 AM 5:45 * * * *

* * * * * * * * * * * * * * * * 23:55
this is the formula that i used
* * * * * * * * * * * * * * * * * * * * =SUM(C1:C8)