Yes this interests me. It would be nice to not have to use the : to complete
the cell. If your formula can let me enter the data with the min.sec and
then it changes it to a min:sec. That would be great.

"Pete_UK" wrote:

If you have a lot of times to enter, it can be very tedious to have to
type the colons if you use the numeric keypad. Instead, I enter min:sec
as min.sec and then convert it into min:sec - I'll let you have the
formulae if this is of interest to you.

Other things that you might consider is to work out the rate charged
for each call type and compare this with published tariffs.

Hope this helps.

Pete