seperating time

O

Oreg

Hello,

is there a function I can use that will seperate time from one cel
into 2 cells. Example: Column A is a list of times (military), A
=(13:37) I would like B1 to display 13 and C1 to display 37.

Thank
 
P

Peo Sjoblom

B1=HOUR(A1)
C1=MINUTE(A1)

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
B

beeawwb

If it's just text, the following might work. (Only works if the cell i
formatted as text, otherwise, the value for 13:37 is 0.56736111111111
which doesnt contain ":")

B1 =LEFT(A1,(FIND(":",A1,1))-1)
C1 =RIGHT(A1,LEN(A1)-FIND(":",A1))

-Bo
 
Top