Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Collection custom functions as asn addin | Excel Discussion (Misc queries) | |||
Custom Functions | Excel Discussion (Misc queries) | |||
need custom cut and paste functions | New Users to Excel | |||
Using custom functions within custom validation | Excel Discussion (Misc queries) | |||
Custom Functions | Excel Worksheet Functions |