How to read the text of cutom time e.g. 7:00 AM?

[Ai_Jun_Zhang]

Hi!

In my cell, it uses the Custom Number for a time h:mm AM/PM. That is: the cell is defined as Number with custom format h:mm AM/PM.

It shows right in the cell. For example, it shows as 7:00 AM. However, when I read the cell using VBA, it reads as 0.29166. For example, lets row 1, col is shown as 7:00 AM, VBA will read cells(1, 1) as 0.29166 instead of 7:00 AM.

Can anybody help me with this? How can I read the time as it is showed in the cell?

Thank you very much for your help.

Regards,
Aijun.

[Excelenator]

Use

CDate(Range("A1").Value)