Home |
Search |
Today's Posts |
#1
|
|||
|
|||
adding time in 2k7
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 |
#2
|
|||
|
|||
Nevermind. I was able to figure it out. took it out and put it back into a new sheet and worked. Thanks
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding time | New Users to Excel | |||
adding time | Excel Discussion (Misc queries) | |||
Adding time | Excel Discussion (Misc queries) | |||
Time log adding time from separate sheets | New Users to Excel | |||
Adding time to date-time formatted cell | Excel Discussion (Misc queries) |