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

"Bill Sharpe" wrote in message
...
David Biddulph wrote:
But why would he want to display as 7.48 (which it isn't) in place of
7:48 (which it is)?
--

You could modify/complicate the formula to change it to text and replace
the period with a colon. However, I think that 7.48 is a big improvement
over 7.8 and understandable to the original poster. He could also split
the formula into two separate formulas and place the minutes in one column
and the seconds in the next column and put a heading at the top of the two
columns. If you really wanted to, you could use three columns and put the
colon in the middle one. <vbg

Bill