PC Review


Reply
Thread Tools Rate Thread

Adding hours, minutes and seconds

 
 
New Member
Join Date: Dec 2009
Posts: 2
 
      24th Dec 2009
Hi Guys I need some help, I have a large number of cells with format 00:00:00 I need to sum them, in other words I need to get the total of an entire column with time in that format, how can I do it.

IE
01:25:33
02:22:42
00:48:55
01:33:32

xx:xx????

Thanks!
 
Reply With Quote
 
 
 
 
Yorkshire Cruncher
nivrip's Avatar
Join Date: Mar 2007
Location: North Yorkshire
Posts: 3,796
 
      24th Dec 2009
Check out Excel Help > Date and Time Formulas > Add Times

 
System Spec

Colossus 1943 Version 1.0
 
Reply With Quote
 
New Member
Join Date: Nov 2007
Posts: 24
 
      31st Dec 2009
In Final cell or for column change format to Format /Number / Custom / [h];mm;ss
this will give you a total sum of all times ie: if you add to your example 10:03:45 and 12:00:00
the result will be total time ie 28:14:27 as opposed to 04:14:27 which you will get in the Time format

Have fun...
 
Reply With Quote
 
New Member
Join Date: Dec 2009
Posts: 2
 
      31st Dec 2009
Now that's what I call an answer!!

Thank you Chuck!

Robert
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert seconds to days, hours, minutes and seconds. Sheldon Microsoft VB .NET 5 6th Jul 2008 03:09 PM
Adding/subtracting time and displaying hours, minutes, seconds NEMO Microsoft Excel Discussion 2 17th Apr 2008 06:51 AM
Calculating and Adding Hours, Minutes, and Seconds in a CALL LOG =?Utf-8?B?RW1hbkpS?= Microsoft Excel Worksheet Functions 1 3rd Aug 2006 03:47 PM
Adding hours minutes and seconds =?Utf-8?B?V2FubmFDaGV2eTAz?= Microsoft Excel Worksheet Functions 5 1st Feb 2006 02:42 PM
adding hours and minutes ignoring seconds cbm Microsoft Excel Discussion 4 21st Oct 2005 04:19 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:29 AM.