Originally Posted by Permdawg

I'm trying to add up times in Excel 2k7 and just getting the time of 0:00:00

Here is the numbers i'm trying to addup. Its 81 cells. I have formatted them as time using h:mm:ss and also [h]:mm:ss also with no help either.
Here are the times
00:00:05
00:00:06
00:00:02
00:00:11
00:00:05
00:00:08
00:03:04
00:05:00
00:01:57
00:00:04
00:02:15
00:00:02
00:00:12
00:00:08
00:01:08
00:00:40
00:00:46
00:00:04
00:00:02
00:01:48
00:01:17
00:00:48
00:00:58
00:01:27
00:00:06
00:00:07
00:01:12
00:01:12
00:00:14
00:04:37
00:01:39
00:00:07
00:00:32
00:00:11
00:02:49
00:00:07
00:00:02
00:00:33
00:00:20
00:00:50
00:01:15
00:00:12
00:00:12
00:02:03
00:00:42
00:02:29
00:00:51
00:00:04
00:00:05
00:03:59
00:01:55
00:00:05
00:00:10
00:00:06
00:00:01
00:00:57
00:01:02
00:01:44
00:00:10
00:00:05
00:00:25
00:00:08
00:01:34
00:00:07
00:00:06
00:00:07
00:00:19
00:00:16
00:00:00
00:00:52
00:00:11
00:01:02
00:00:05
00:00:04
00:00:49
00:01:26
00:00:10
00:00:08
00:00:49
00:00:05
00:00:02

Not sure wh