#1
|
|||
|
|||
Adding a long column of time increments in seconds
adding imported time segments, mainly in seconds. ( :ss)
Daily, I import a long column of data broken down in time (minutes and seconds) up to 150 rows. I need to get a sum of the entire column. The numbers, minutes and seconds, appear randomly in the rows. example; :55 :33 :48 1:48 :31 :03 12:34 The sum should be 17:12 (mm:ss) Because of the random mixed formatting ( :ss & mm:ss) I can't seem to find a cell formatting that works well for adding these. The final result, I want to display in the format h:mm:ss (often totals are around 18 hrs, 25 min, 32 sec - 18:25:32) Any help would be greatly appreciated. |
#2
|
|||
|
|||
Hi,
I assume that you import a textfile. In case yes, assign the : sign as delimiter. Now you get two columns. The first column (A) with minutes you just make a sum of. The second column (B) with seconds you make a sum of and divide the result by 60. After this you just summarize the two sums (A+B) and divide the result by (60*24) to get the result in days. This you format as hh:mm:ss. If the total is more than 24 hours you have to handle this by special formulas. Kind regards Bjorn |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
adding text on a separated column line | ahmet1985 | Word | 0 | 03-27-2010 07:10 AM |
Long List for drop down box | DLo99 | Word | 0 | 02-28-2010 08:07 AM |
Moving a Long Document | clpix | Word | 1 | 01-14-2010 08:55 PM |
16 seconds | Scott@Geeks | Word | 0 | 02-24-2009 01:06 PM |
Specific Lat Long Conversion Help | chesspupil | Excel | 2 | 04-16-2006 11:06 PM |