Rasscal
02-06-2020, 04:40 AM
hi all,
i have a useform textbox controlled by a spin button that a user will input time taken to complete a task, this works fine in increments of 15mins (0.25)
however the output isnt very user friendly,
me.txthours.value is then sent to a DB and a calculation (value*hourly rate) hence why its in 0.25 values.
Private Sub sbTime_SpinUp()
Me.txtHours.value = Me.txtHours.value + 0.25
End Sub
value output displayed
Disired Display value
0.25
15
0.5
30
0.75
45
1
1
1.25
1:15
1.5
1:30
1.75
1:45
2
2
2.25
2:15
2.5
2:30
2.75
2:45
3
3
any help with this would be greatly appreciated.
i have a useform textbox controlled by a spin button that a user will input time taken to complete a task, this works fine in increments of 15mins (0.25)
however the output isnt very user friendly,
me.txthours.value is then sent to a DB and a calculation (value*hourly rate) hence why its in 0.25 values.
Private Sub sbTime_SpinUp()
Me.txtHours.value = Me.txtHours.value + 0.25
End Sub
value output displayed
Disired Display value
0.25
15
0.5
30
0.75
45
1
1
1.25
1:15
1.5
1:30
1.75
1:45
2
2
2.25
2:15
2.5
2:30
2.75
2:45
3
3
any help with this would be greatly appreciated.