David Biddulph wrote:
But why would you want to go through that sort of nausea to put a colon in a
text string, when Excel time format will display 7:48 as 7:48 anyway? Why
not use it the way it's intended?
--
David Biddulph

You're right, and a much easier approach including the input you suggested.

Bill