Split a cell ?

[Jim Melton]

How can I take one cell and split it in to two cells?
I have a (A) column with the time (24hr format) I need to put the hour in
column (b) and the minutes in a column (c)

 

[Bernie Deitrick]

Jim,

IF your time is a valid time value in cell A1, then in cell B1, use the
formula
=Hour(A1)

In cell C1, use the formula
=Minute(A1)

Copy B1:C1 down to match your data in column A.

Copy B:C and pastespecial values, then delete column A, if you want.

HTH,
Bernie
MS Excel MVP

 

[Jim Melton]

Thank You

Jim,

IF your time is a valid time value in cell A1, then in cell B1, use the
formula
=Hour(A1)

In cell C1, use the formula
=Minute(A1)

Copy B1:C1 down to match your data in column A.

Copy B:C and pastespecial values, then delete column A, if you want.

HTH,
Bernie
MS Excel MVP