It's hard to say because you didn't tell us where you want the converted
results... back in the same cell or in a different cell. Generally, you
would use this...

Cells(SomeRow, SomeColumn).Value = Format(Cells(2, "C").Value,"hhmm")

--
Rick (MVP - Excel)


"Steved" wrote in message
...
Hello from Steved

How do I please put the below in VBA

for example it converts 2:24 to 1424

=HOUR(C2)*100+MINUTE(C2)

ps yes I've Got Col C:C with about 200 to convert

I Thankyou.