Thanks Biff this worked perfect, Petes solution worked also,
two different ways of doing the same thing, never came across
Biffs way of doing this before so will use this solution

While it doesn't harm anything, Biff's formula has an extraneous set of
parentheses in it. This version of it will work just as well...

=--TEXT(A1,"00\:00")

Rick