You keep calling it "a macro"

It is not a macro...............it is a Function

If it did not exist in your workbook you would get #NAME? in the cells with
that formula.


Gord

On Mon, 04 Jan 2010 13:44:45 -0700, Howard Brazee wrote:

On Mon, 04 Jan 2010 13:35:52 -0700, Howard Brazee
wrote:

Those cells would have a format of '12-5
or '12-5:1:2
or '12-5:1:2:C


Odd, this seems to work if column C doesn't have a colon. If the 2nd
option is in column d it works, but if it's in column c, I get an
error.

The following are my results in columns B, C, & D

179 9-7 12-4:3:0:C
M 13:3:0:1 11-5:1:0 9-7

This implies that there is a broken macro somewhere. I just need to
find it.