Split hours and minutes in two different cells
 

On Friday, October 15, 2010 2:11:49 AM UTC+5:30, Ron Rosenfeld wrote:
On Thu, 14 Oct 2010 12:48:41 -0700 (PDT), 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


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



very nice answer