Time to counting

[ks1102]

hi experts
i have a spreadsheet range E to down contents a time with ( format 01:30, 00:58 .. ) else ... how do i using if cells value < 01:00 then
, but seem it not work ?

can u help and learn me more than

[tehneXus]

Hi,

try

 If Hour(Cells(1, 1).Value) < 1 Then
 'sth
 End If