Google-sheets – How to improve the current spreadsheet time formula

Maybe try using this function instead of NOW()

=GoogleClock()

GoogleClock()

Returns the current date and time according to your computer system. Updates automatically each minute on the minute (unlike the NOW function). No arguments are used in this function.

EDIT:

GOOGLECLOCK is not available in the new Google Sheets. To get the same results, use the NOW function and change your recalculation setting to "On change and every minute" in your spreadsheet at File > Spreadsheet settings.

The following little piece of code gives you the result, without prior knowledge about the character code number.

Code

function mySplit(range, delimiter) {
  var output = [], maxCol = range[0].length;
  for(var i=0, iLen=range.length; i<iLen; i++) {
    var colCounter=0, counter=0;
    for(var j=0, jLen=range[0].length; j<jLen; j++) {
      if(range[i][j] == "") {
        colCounter++;
      } else {
        if(range[i][j].split(delimiter).length > 1) {
          counter++;
        }
      }
    }
    output.push(counter + "/" + (maxCol - colCounter));
  }  
  return output;  
}

Screenshot

Example

I've created an example file for you: Certain Text Characters
If you copy the file, then you can access the code. Add the code into your existing sheet by going to Tools\Script editor in the main menu. Paste the code and save.