Split hours and minutes in two different cells

  • Thread starter Thread starter siva
  • Start date Start date
S

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
 
Try these...

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

Make sure the cells end up formatted as General.
 
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
Click to expand...

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