On Tue, 14 Nov 2006 14:08:01 -0800, Steve
wrote:

now, next problem

Assuming I range out the time differences it the two of the columns, such
as: start at 1:04, end at 1:20, to get :16 in a new column. All these times
correspond to 1 of 4 different machines. For example 1, 2, 3, or 4 in column
A. What formula could I use to get the total time used for #1, for #2, etc.
Basically I want to show # 1 as :40, # 2 as :13, etc.
1 :16
1 :20
1 :04
2 :02
2 :08
2 :03


Something like:

=SUMIF(A1:A6,1,B1:B6)


--ron