Problems with my google spreadsheet

  • Profile Image
    Asked on September 28, 2012 at 11:12 AM

    when this is linked to my google spreadsheet, the timestamp for 10am this morning says 1500.... that is not correct. how do i fix?

  • Profile Image
    Answered on September 28, 2012 at 11:37 AM

    This is something you can correct into the Date Format of the Spreadsheet

    Just click on the column where TimeStamp is  and look for Data Validation. Then make sure it is set to your timezone and into Date format