问Google电子表格

EN

function oversimplified_time_format_converter(input){
  if(input.indexOf("PM")!==-1){
    var hour = 12 + (input.substring(0,input.indexOf("PM"))*1)
    if(hour>24){hour-=24}
  } else {
    var hour = input.substring(0,input.indexOf("AM"))
    }
  return hour
  }

function yourFunction() {

  //First, locate your data:
  var sheet = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheet/yourspreadsheetURL").getSheetByName("YourSheetName")
  var cell = sheet.getRange("A1")
  var cell_contents = cell.getValue() //The cell contents will be "1PM -5PM"

  //Next, locate the cells where the results will go
  var first_cell_to_the_right = cell.offset(0,1) //This is cell B1
  var second_cell_to_the_right = cell.offset(0,2) //This is cell C1

  //Next, get the text, split it into separate strings
  var first_part = cell_contents.substring(0,cell_contents.indexOf(" - ")) //This will be "1PM"
  var second_part = cell_contents.substring(cell_contents.indexOf(" - ")+3) //This will be "5PM"

  //Now convert to 24-hour time format:
  first_part = oversimplified_time_format_converter(first_part)
  second_part = oversimplified_time_format_converter(second_part)

  //Now write the results to your spreadsheet
  first_cell_to_the_right.setValue(first_part) //Set value of B1 to "1PM"
  second_cell_to_the_right.setValue(second_part) //Set value of C1 to "5PM"
}