Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-07-2010, 12:42 PM
klippert klippert is offline Adding a long column of time increments in seconds Windows XP Adding a long column of time increments in seconds Office 2007
Novice
Adding a long column of time increments in seconds
 
Join Date: Sep 2010
Posts: 1
klippert is on a distinguished road
Question 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.
Reply With Quote
  #2  
Old 09-18-2010, 12:26 AM
BjornS BjornS is offline Adding a long column of time increments in seconds Windows Vista Adding a long column of time increments in seconds Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

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
Reply With Quote
Reply

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
Adding a long column of time increments in seconds 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
Adding a long column of time increments in seconds Specific Lat Long Conversion Help chesspupil Excel 2 04-16-2006 11:06 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:13 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft