Times are just numbers, a fraction of a 24 hour day (6:00 = 0.25,
12:00 = 0.5, 18:00 = 0.75 etc), so you can just add them up normally.
Format the result cell with a custom number format of [hh]:mm. The
square brackets prevent Excel from "rolling over" the hours at 24:00.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]


On Sun, 20 Dec 2009 15:08:01 -0800, Mike <Mike
@discussions.microsoft.com wrote:

I am trying to add times such as 28:00,35:00,12:00 and I keep getting zero
for the sum, could someone please give me a formula or format for this
problem.

Thanks,

Mike