roshinpp_77 wrote:

HI friends,
Could anyone tell me how to extract first two digits of a "Time
value"

For example in cell B10 the content is 12:00 ie..(Time)
I am not able to extract "12" ie the first two digits of that time.

I am getting 0.5013 when taken as text.


Regards,
TIA


Roshin


Hello,
use this left(range("B10").text,2)

Mike,Luxembourg