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