Hi,
Try this :
Text1.Text = Format(0.965972222 ,"HH:MM")
Regards
Veena
Hi Veena,
Its working fine now. I had tried this function before, but at that time it is working erronously ie. for some values it is showing correct format , but for others not.
I have find out the problem. It is with worksheets. My excel sheet contain several worksheets, and I was using the wrong one.After using the correct worksheet it is solved.Anyway, thank you for your help.