"Browner" wrote in
message ...

what about if some of them appear as such:

:05:00
:03:00

How can i get the "HH" to show up as Zero's?

b/c some of the data set already have the ":" before the first value
and i can't get it to show up as "hh:mm:ss".

Are you sure that the cells aren't formatted as text, rather than as times?
You may need to convert from text to times before your format will work.
--
David Biddulph