Sub 日程記載変換()
Dim c As Date
Dim bc As Date
str1 = Cells(1, 1).Value
day1 = Split(str1, "-")
Cells(1, 3).Value = "開始日時"
Cells(2, 3).Value = " " & Trim(day1(0)) & " (JST)"
Cells(5, 3).Value = "終了日時"
Cells(6, 3).Value = " " & Trim(day1(1)) & " (JST)"
Cells(9, 3).Value = "start"
Cells(13, 3).Value = "end"
d2 = Split(day1(0), "(")
d3 = Split(day1(0), ")")
dd2 = d2(0)
tt2 = d3(1)
c = dd2 & " " & tt2
c2 = c
c = DateAdd("h", -9, c)
cy = WeekdayName(Weekday(c), True)
e = Split(c, " ")
If UBound(e) = 0 Then
e = c & " 00:00"
f = c
g = Split(f, "/")
f2 = "00:00"
h = " " & Format(f, "yyy") & "年" & Format(f, "mm") & "月" & Format(f, "dd") & "日(" & cy & ")" & " " & "00" & "時" & "00" & "分" & " (UTC)"
Else
f = e(0)
g = Split(f, "/")
f2 = e(1)
g2 = Split(f2, ":")
h = " " & Format(f, "yyyy") & "年" & Format(f, "mm") & "月" & Format(f, "dd") & "日(" & cy & ")" & " " & Format(f2, "hh") & "時" & Format(f2, "nn") & "分" & " (UTC)"
End If
Cells(3, 3).Value = h
Cells(10, 3).Value = Format(c2, "yyyy/mm/dd hh:nn") & " (JST)"
Cells(11, 3).Value = Format(c, "yyyy/mm/dd hh:nn") & " (UTC)"
bd2 = Split(day1(1), "(")
bd3 = Split(day1(1), ")")
bdd2 = bd2(0)
btt2 = bd3(1)
bc = bdd2 & " " & btt2
bc2 = bc
bc = DateAdd("h", -9, bc)
bcy = WeekdayName(Weekday(bc), True)
be = Split(bc, " ")
If UBound(be) = 0 Then
be = bc & " 00:00"
bf = bc
bg = Split(bf, "/")
bf2 = "00:00"
bh = " " & Format(bf, "yyy") & "年" & Format(bf, "mm") & "月" & Format(bf, "dd") & "日(" & bcy & ")" & " " & "00" & "時" & "00" & "分" & " (UTC)"
Else
bf = be(0)
bg = Split(bf, "/")
bf2 = be(1)
bh = " " & Format(bf, "yyyy") & "年" & Format(bf, "mm") & "月" & Format(bf, "dd") & "日(" & bcy & ")" & " " & Format(bf2, "hh") & "時" & Format(bf2, "nn") & "分" & " (UTC)"
End If
Cells(7, 3).Value = bh
Cells(14, 3).Value = Format(bc2, "yyyy/mm/dd hh:nn") & " (JST)"
Cells(15, 3).Value = Format(bc, "yyyy/mm/dd hh:nn") & " (UTC)"
End Sub