====== 2020.03.07 Excelでunixtime ======

===== 日時（日本標準時）　→　UnixTimestamp =====

  =(($a$1 - 25569) * (60 * 60 * 24)) - (60 * 60 * 9)

=== 例 ===

  "2019/9/30 23:59:59" -> 1569855599 


===== UnixTimestamp　→　日時（日本標準時） =====

  =25569 + (($a$1 + (60 * 60 * 9)) / (60 * 60 * 24))


=== 例 ===

  1569855599 -> "2019/9/30 23:59:59" 


{{tag>日記 Excel}}