display part of a time in another cell

[critter]

I wanted to know if there is an function/formula that I
can use in Excel 2002 that would take a time displayed in
cell A1 and display the only the hour in cell A2, and
only the minutes in cell B2?

 

[Frank Kabel]

Hi
in A2:
=HOUR(A1)
B2:
=MINUTE(A1)

 

[Arvi Laanemets]

Hi

A2=INT(A1*24)
B2=INT((A1*24-INT(A1*24))*60)
or (depends on have you seconds entered or not)
(A1*24-INT(A1*24))*60
and format as general

 

[Critter]

Thank you Very Much!

-----Original Message-----
Hi
in A2:
=HOUR(A1)
B2:
=MINUTE(A1)

--
Regards
Frank Kabel
Frankfurt, Germany



.

 

[critter]

thanks.

-----Original Message-----
Hi

A2=INT(A1*24)
B2=INT((A1*24-INT(A1*24))*60)
or (depends on have you seconds entered or not)
(A1*24-INT(A1*24))*60
and format as general


--
Arvi Laanemets
(When sending e-mail, use address arvil<At>tarkon.ee)






.