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
|