sum time

livermore

New Member
Joined
Feb 23, 2011
Messages
39
Hi

I have a column with the following numbers

00:00:15
00:00:48
00:02:02
01:00:23
00:23:54
00:01:23

<tbody>
</tbody>

These indicate the time spent waiting for a response.
I want to be able to sum all these values but for that I need to make them recognizable to excel.

How can I set these values are time and that excel allow me to sum them?
What type of format do I need to use?

thank you
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

gaz_chops

Well-known Member
Joined
Apr 29, 2003
Messages
6,468
Platform
MacOS
Have you tried to sum them? If they are entered as you show them then it should work.

Code:
[TABLE="width: 91"]
<tbody>[TR]
[TD="class: xl63, width: 91, align: right"]00:00:15[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]00:00:48[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]00:02:02[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]01:00:23[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]00:23:54[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]00:01:23[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]01:28:45[/TD]
[/TR]
</tbody>[/TABLE]
 

livermore

New Member
Joined
Feb 23, 2011
Messages
39
here is a screenshot




the result is zero

for sure I'll need to change the format but so far I haven't been able to.
 
Last edited:

livermore

New Member
Joined
Feb 23, 2011
Messages
39
PERFECT!

Thank you so much gaz_chops.

You're the best!
 

gaz_chops

Well-known Member
Joined
Apr 29, 2003
Messages
6,468
Platform
MacOS
This also works & is not an array formula

=SUMPRODUCT(A1:A6+0)
 

Watch MrExcel Video

Forum statistics

Threads
1,102,630
Messages
5,487,998
Members
407,617
Latest member
Samanthad2007

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top