View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
subvanpatent subvanpatent is offline
external usenet poster
 
Posts: 4
Default Writing a VBA program

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.

Thanks,
--
Jim