Dim D As Long Dim F As Double Dim M As Double Dim k As Double k = 2.35 D = k \ 1
F = k - D F = F * 60
M = F - F \ 1 F = F - MD:度 F:分 M:秒
Private Sub Command1_Click() Dim x As Double, dfm As String x = CDbl(InputBox("please enter a degree for trans ;", "INFO", "120.375")) dfm = x & "°=" & Int(x) & "°" x = (x - Int(x)) * 3600 dfm = dfm & Format(TimeSerial(0, 0, x), "nn′ss″") MsgBox dfm End Sub
Dim F As Double
Dim M As Double
Dim k As Double
k = 2.35
D = k \ 1
F = k - D
F = F * 60
M = F - F \ 1
F = F - MD:度
F:分
M:秒
Dim x As Double, dfm As String
x = CDbl(InputBox("please enter a degree for trans ;", "INFO", "120.375"))
dfm = x & "°=" & Int(x) & "°"
x = (x - Int(x)) * 3600
dfm = dfm & Format(TimeSerial(0, 0, x), "nn′ss″")
MsgBox dfm
End Sub