I am trying to write a script to help me determine the Mean Time Between Repair for equipment. I played with it all day yesterday but was not able to figure it out. Right now I have to enter the string manually. The formula I am using is "=AVERAGE(C7-C6,C6-C5,C5-C4,C4-C3,C3-C2)" where C7 would be the latest date to C2 the earliest date. As you can see this would become cumbersome with numerous dates. -- Jim
subvanpatent wrote: > I am trying to write a script to help me determine the Mean Time > Between Repair for equipment. I played with it all day yesterday but > was not able to figure it out. Right now I have to enter the string > manually. The formula I am using is > "=AVERAGE(C7-C6,C6-C5,C5-C4,C4-C3,C3-C2)" where C7 would be the > latest date to C2 the earliest date. As you can see this would > become cumbersome with numerous dates. -- > Jim Boy, are you in the wrong place!! :-) 1. VBA is not vbscript. 2. inetsdk refers to programming internet applications, not Office It looks like you are using Excel, so you need to go into the Office Solutions node over there in the table of contents and navigate to the Excel VBA group(s). There is also a much-used forum for Excel users at http://www.mrexcel.com/forum/index.php?s=842adad78fef7834e54f98f657ea4d0c if you prefer that route -- Microsoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup.
