View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] subway22523@gmail.com is offline
external usenet poster
 
Posts: 1
Default Split hours and minutes in two different cells

On Friday, 15 October 2010 01:18:41 UTC+5:30, siva wrote:
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