title: Validation for date time fields in google sheets
body: <p>I have made a simple Google form with three fields.</p>
  
  <ol>
  <li>Cabin (dropdown) </li>
  <li>From (datetime)</li>
  <li>To (datetime)</li>
  </ol>
  
  <p>Before I hit the submit button, I need to validate two things</p>
  
  <ol>
  <li>date time entered in "To" should be greater than "From"</li>
  <li>time difference should be less than 16 hours</li>
  </ol>
  
  <p>I have searched everywhere but could not find a setting to add this validation. I have searched google and StackOverflow posts for a similar query but could not find anything that matches my requirement.</p>
  
  <p>I am attaching a screenshot of the google form and also the google form URL. Please help me on how to achieve this.</p>
  
  <p>Google Form URL: <a href="https://docs.google.com/forms/d/e/1FAIpQLScI_Ixdrm4gPIl8O-Lb9_VrYbwq_uDPWHGKGsDKZk-5_BWfgA/viewform" rel="nofollow noreferrer">https://docs.google.com/forms/d/e/1FAIpQLScI_Ixdrm4gPIl8O-Lb9_VrYbwq_uDPWHGKGsDKZk-5_BWfgA/viewform</a></p>
  
  <p><a href="https://i.stack.imgur.com/fs3w3.png" rel="nofollow noreferrer">Google Form</a></p>