Time without date
 

The below is in a pre-dowloaded column, column L
11/14/06 4:19
It has custom formatting as m"/"d"/"yy" "h":"mm

What formula do I need to enter in the M column to just show the 4:19,
keeping the h:mm formatting, because I still need to subtract a time in one
column from a time in another column.

Thanks,

Steve

Time without date
 

Steve

Assuming the date/time is in column L2, in M2 put: =L2 and format as
hh:mm

Note that you don't need the quote marks in your format

Regards

Trevor


"Steve" wrote in message
...
The below is in a pre-dowloaded column, column L
11/14/06 4:19
It has custom formatting as m"/"d"/"yy" "h":"mm

What formula do I need to enter in the M column to just show the 4:19,
keeping the h:mm formatting, because I still need to subtract a time in
one
column from a time in another column.

Thanks,

Steve

Time without date
 

Try this:

=MOD(L1,1)

Format as h:mm

Biff

"Steve" wrote in message
...
The below is in a pre-dowloaded column, column L
11/14/06 4:19
It has custom formatting as m"/"d"/"yy" "h":"mm

What formula do I need to enter in the M column to just show the 4:19,
keeping the h:mm formatting, because I still need to subtract a time in
one
column from a time in another column.

Thanks,

Steve

Time without date
 

Thanks both much. I knew it was something simple I just couldn't remember.

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


Thanks again,

"Biff" wrote:

Try this:

=MOD(L1,1)

Format as h:mm

Biff

"Steve" wrote in message
...
The below is in a pre-dowloaded column, column L
11/14/06 4:19
It has custom formatting as m"/"d"/"yy" "h":"mm

What formula do I need to enter in the M column to just show the 4:19,
keeping the h:mm formatting, because I still need to subtract a time in
one
column from a time in another column.

Thanks,

Steve

Time without date
 

Try this:

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

Or, use cells to hold the machine number:

C1 = 1
C2 = 2
C3 = 3

Then, in say, D1:

=SUMIF(A$1:A$6,C1,B$1:B$6)

Copy down to D3

Format to suit.

Biff

"Steve" wrote in message
...
Thanks both much. I knew it was something simple I just couldn't remember.

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


Thanks again,

"Biff" wrote:

Try this:

=MOD(L1,1)

Format as h:mm

Biff

"Steve" wrote in message
...
The below is in a pre-dowloaded column, column L
11/14/06 4:19
It has custom formatting as m"/"d"/"yy" "h":"mm

What formula do I need to enter in the M column to just show the 4:19,
keeping the h:mm formatting, because I still need to subtract a time in
one
column from a time in another column.

Thanks,

Steve

Time without date
 

Perfect. Thanks much.

"Biff" wrote:

Try this:

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

Or, use cells to hold the machine number:

C1 = 1
C2 = 2
C3 = 3

Then, in say, D1:

=SUMIF(A$1:A$6,C1,B$1:B$6)

Copy down to D3

Format to suit.

Biff

"Steve" wrote in message
...
Thanks both much. I knew it was something simple I just couldn't remember.

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


Thanks again,

"Biff" wrote:

Try this:

=MOD(L1,1)

Format as h:mm

Biff

"Steve" wrote in message
...
The below is in a pre-dowloaded column, column L
11/14/06 4:19
It has custom formatting as m"/"d"/"yy" "h":"mm

What formula do I need to enter in the M column to just show the 4:19,
keeping the h:mm formatting, because I still need to subtract a time in
one
column from a time in another column.

Thanks,

Steve

Time without date
 

You're welcome. Thanks for the feedback!

Biff

"Steve" wrote in message
...
Perfect. Thanks much.

"Biff" wrote:

Try this:

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

Or, use cells to hold the machine number:

C1 = 1
C2 = 2
C3 = 3

Then, in say, D1:

=SUMIF(A$1:A$6,C1,B$1:B$6)

Copy down to D3

Format to suit.

Biff

"Steve" wrote in message
...
Thanks both much. I knew it was something simple I just couldn't
remember.

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


Thanks again,

"Biff" wrote:

Try this:

=MOD(L1,1)

Format as h:mm

Biff

"Steve" wrote in message
...
The below is in a pre-dowloaded column, column L
11/14/06 4:19
It has custom formatting as m"/"d"/"yy" "h":"mm

What formula do I need to enter in the M column to just show the
4:19,
keeping the h:mm formatting, because I still need to subtract a time
in
one
column from a time in another column.

Thanks,

Steve

Time without date
 

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