7 Replies Latest reply on Oct 24, 2014 1:56 AM by Test Screen Name

    Javascript help!


      So I used this formula from a different sheet that still currently works to calculate time in a different sheet


      var cIn = "TimeIn.0", cOut = "TimeOut.0";  

      event.value = TimeDiff("HH:MM", cIn, cOut);

      // convert zero entry to null

      if(event.value == 0) event.value = "";



      to do the exact same thing. Yesterday everything was smooth sailing and all the calculations worked!

      Allowed my little sister to do some research on my computer that afternoon and now today when I try to

      get my form to work properly it doesn't respond and acts like I haven't put in a custom calculation script.


      HOW!? I'm very confused. The script is the same. The names of the boxes are the same... why doesn't my script work!?