the formula used to display the work hour values from another worksheet
(CR1203) is

={IF(I160,INDEX('CR1203'!$I$8:$I$2001,MATCH(F16&" ",LEFT('CR1203'!$C$8:$C$2001,4),0)),"")}

I don't know if it's this formula that won't allow me to use sum() to add
the values or if it's the way the data was downloaded on to the sheet named
CR1203 (which is in the same format as below). If I break up the way it's
added (i.e. A1+A2+etc), it works. But if there are blank cells in between
the values,

Column A
Row 1 04:31:26
Row 2 01:14:19
Row 3
Row 4 01:57:24

it will not add them up.


"Peter Andrews" wrote:


"GAIDEN" wrote in message
...
work hours
04:31:26
01:14:19
01:57:24
02:27:32
03:01:01
02:42:15
02:34:16
02:11:15
02:17:57
00:24:35
02:03:44
01:10:22
03:23:12
10:09:12

I'm trying to add these work hours together and all i keep getting is
0:00:00. I've also tried formatting the work times (Example: 04:31:26 to
4.52 hours) without luck.

Adds to 40:08:30 for me... make sure that all the cells are custom
formatted as hh:mm:ss

Peter