G
Guest
Hello, I have a form named frmDecimalConversion. And on this form I have two
text boxes (txtMinutes and txtDecimal) the txtMinutes you enter your minutes
into and the txtDecimal wil convert to decimals. Example:
480 minutes (typed into txtMinutes) will give you a result of 8 in the
txtDecimal box
Here is the code in the After Update in the txtMinutes box.
Private Sub txtMinutes_AfterUpdate()
Me.txtDecimal = Round(Me.txtMinutes / 60, 2)
End Sub
Everything works great except I want to change from minutes to short time
(Example)
4:45 typed into txtMinutes box will result in 4.75 in the txtDecimals box.
Can someone help me on the VBA code for the formula? instead of the
Me.txtDecimal = Round(Me.txtMinutes / 60, 2)
Thanks!!
text boxes (txtMinutes and txtDecimal) the txtMinutes you enter your minutes
into and the txtDecimal wil convert to decimals. Example:
480 minutes (typed into txtMinutes) will give you a result of 8 in the
txtDecimal box
Here is the code in the After Update in the txtMinutes box.
Private Sub txtMinutes_AfterUpdate()
Me.txtDecimal = Round(Me.txtMinutes / 60, 2)
End Sub
Everything works great except I want to change from minutes to short time
(Example)
4:45 typed into txtMinutes box will result in 4.75 in the txtDecimals box.
Can someone help me on the VBA code for the formula? instead of the
Me.txtDecimal = Round(Me.txtMinutes / 60, 2)
Thanks!!