Time formate in hour and mints

[zahid ali]

hi every one,
i trying to wirte time in below formate but facing problems

[TABLE="width: 500"]
<tbody>[TR]
[TD]Available data[/TD]
[TD]Need to write[/TD]
[/TR]
[TR]
[TD]3:50[/TD]
[TD]3 Hr 50 min[/TD]
[/TR]
[TR]
[TD]2:15[/TD]
[TD]2 Hr 15 min[/TD]
[/TR]
</tbody>[/TABLE]

 

[AlanY]

how about?

=HOUR(A1)&" hr "&MINUTE(A1)&" min"