Gary, thank you for the prompt reply on my first question it works
wonderfully, unfortunately, I don't understand how.

Also, do you know an answer to my timing question or should I post that
separately?

I don't understand the function syntax.
If the MOD function help, it shows MOD(number,divisor)
How does SCounts Mod 8 work and how would I know this syntax?

Thank you.

"Gary''s Student" wrote:

Function OL(SCounts As Integer) As Integer
OL = 8 - SCcounts Mod 8
End Function

and in the worksheet used like =OL(64) which returns 8
--
Gary''s Student - gsnu200764


"DTTODGG" wrote:

Hello,

I'm trying to make 2 functions. These will be my first homemade functions,
so please be specific when helping me :-)

First, in Module1 I tried:

Function OL(SCounts)
OL=8-MOD(SCounts,8)
End Function

This gave me errors. Can you nest a function "MOD" within a custom function?
It worked ok when I left out the MOD function (OL=8-2).

-----------------------------
Second, is there an already made function to convert text to mm:ss.hh?

I'm trying to work with stopwatch times (minutes, seconds, hundredths). I
need to be able to add, subtract, average, etc...

Thank you so much for sharing your wisdom.