Split hours and minutes in two different cells

[siva]

Hi All,

I would like to have hours and minutes in 2 differnet cells from a cel
which contains a value in HH:MM format

Example
A B C

18:30 18 30

 

[Ron Rosenfeld]

Hi All,

I would like to have hours and minutes in 2 differnet cells from a cel
which contains a value in HH:MM format

Example
A B C

18:30 18 30

b1: =int(a1*24)
c1: =minute(a1)

 

[Rick Rothstein]

Try these...

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

Make sure the cells end up formatted as General.

 

[Ron Rosenfeld]

Try these...

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

Make sure the cells end up formatted as General.

Note that HOUR only works as desired if Time is less than 24 hours.

 

[subway22523]

Hi All,

I would like to have hours and minutes in 2 differnet cells from a cel
which contains a value in HH:MM format

Example
A B C

18:30 18 30

MY CELL IS NOT REFLICTING FOR MINUTES
AS I AM USING WINDOW XP 2003

 

[selvakumarsft]

I would like to calculate in excel as follow;

A B C

4 2 2 4

6 2 4 6

3 2 1 3

 

[guptaarvind68]

b1: =int(a1*24)
c1: =minute(a1)

very nice answer