On Thu, 7 Apr 2005 13:33:07 -0700, Jay wrote:

I have this column AU5 through AU35 which contain time values. What I'd like
to do is add these values together. Is this possible? I also need to acount
for cells which may or may not contain any value at all. Is this possible?
ALL THE RESULTING VALUES I'VE GOTTEN THUS FAR ARE THE WRONG ONES! 00:00 is
really 12 mid-night, I'm not sure if we take those as 12 mid-night or just a
value. Anyway, can anyone out there assist? Thanks,

02:00
00:20
02:05
00:20
00:25
00:00
00:30
01:38

01:57
01:45
00:20

00:40
00:20
01:05
03:00
00:05
00:00
00:00
01:00
00:45


=SUM(AU5:AU35)

Format the result as

Format/Cells/Number/Custom Type: [h]:mm

I get 18:15 for your values above.
--ron