Userform textbox - convert minutes to hours and minutes

[RobbieC]

Hi there, I have a userform with 2 textboxes. One is called 'Time and one is called 'mins'

I'm trying to get the 'Time' textbox to reflect 'mins' textbox in hours and mins ie:

mins = 345 therefore Time = 5:45

I thought I could use something along the lines of:

Sub mins_Change()
Dim minsVar
minsVar = Me.mins.Value
Me.Time.Value = Format(minsVar, "h:mm")
End Sub

or

Sub mins_Change()
Dim minsVar
minsVar = Me.mins.Value
Me.Time.Value = Application.WorksheetFunction.text(minsVar, "h:mm")
End Sub

but both just change Time to 0:00

If you can point me in the right direction, I'd be very happy

Thanks

 

[VBA Geek]

Me.Time.Value = Format(minsVar/1440, "h:mm")

try this

 

[Rick Rothstein]

Hi there, I have a userform with 2 textboxes. One is called 'Time and one is called 'mins'

I'm trying to get the 'Time' textbox to reflect 'mins' textbox in hours and mins ie:

mins = 345 therefore Time = 5:45

I thought I could use something along the lines of:

Sub mins_Change()
Dim minsVar
minsVar = Me.mins.Value
Me.Time.Value = Format(minsVar[B][COLOR="#FF0000"] / 1440[/COLOR][/B], "h:mm")
End Sub

Add what I show in red above (1440 is the number of minutes in a 24-hour day).

 

[RobbieC]

Thanks guys, that's awesome!