VBA Convert Decimal To Time

[dfenton21]

I have a range of cells formatted as time (HH:MM). I am looking for some code to put into the sheet's changed event that will convert a decimal entry into time. i.e. if the user types 9.30, the code will convert it to 9:30.

I've experimented myself, but the best I can do is code that returns 9:03 instead of 9:30.

Any help would be appreciated.

Thanks

P.S. Excel crashed, so I lost the code I referred to above

 

[yogeshmaney]

=TIME(CONVERT(your_Cell_value,"hr","mn")/60,MOD(CONVERT(your_Cell_value,"hr","mn"),60),0)

 

[dfenton21]

Thanks for your help

 

[yogeshmaney]

Welcome Chief !