convert time to string

[Lukael]

Hi,

I have this code for select case statement:

Please Login or Register  to view this content.

It counts data according to cell which is formatted as time ("hh:mm"). It should count according to first string in cell: If time begins with "0", "1" or "2".

Somehow It doesn't recognize first character, I'm assuming time format has something to do with It. Formating cell to General or Number gets this working.

So, what I need is to convert time value from cell into string(text). Tried this but not working :

Please Login or Register  to view this content.

How can I fix this ?

[AlphaFrog]

Try this...

Select Case Left(Format(.Cells(GlavaIme + 2, DateCol), "hh"), 1)

[AlphaFrog]

Another method..

Please Login or Register  to view this content.

[Lukael]

Try this...

Select Case Left(Format(.Cells(GlavaIme + 2, DateCol), "hh"), 1)

Thanks, this one works fine ! Haven't tried second one though...