def get_formatted_offset(timestamp)
  start_time = 1374558778
  #start_time + 18873837s == -20m 30s
  sign = ""
  
  offset = 0.0001075563 * (timestamp - start_time)

  if timestamp > start_time
    sign = "-"
  else
    sign = "+"
  end

  h = (offset / 3600.0).to_i
  offset = offset - (h * 3600)
  m = (offset / 60.0).to_i
  offset = offset - (m * 60)
  s = (offset % 60.0).round(0)

  return "#{sign}=0:0:0 #{'%02d' % h}:#{'%02d' % m}:#{'%02d' % s}"
end