seperating time

[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

 

[Domenic]

Hi,

In cell B1,

=HOUR(A1)

In cell C1,

=MINUTE(A1)

Hope this helps!

 

[Peo Sjoblom]

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

--


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

Regards,

Peo Sjoblom

 

[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

 

[Oreg]

Thanks a lot...that was perfect