title: Formula for subtracting hours from a Date and Time field in a Sharepoint list
body: <p>In a Sharepoint list, i have a date and time field and i want to create a calculated field that subtracts timezone offset from the date and time field (e.g. -6:00). My first attempt at formula was:</p>
  
  <pre><code>DATE(YEAR(Column1),MONTH(Column1),DAY(Column1),HOUR(Column1) – (1/24*offset))
  </code></pre>
  
  <p>But of course there is <strong>NO</strong> hour parameter in the DATE function. How would your correctly write this formula</p>