Hey,
i'm working on a small Project and i'm kind of stuck on this particular point. I have a input box which returns a time value (normally written in the format hh:mm), and i want to convert this to an integer corresponding to a percentage of an hour bascially. For example, 00:30 would give 0.5, 01:15 would give 1.25 etc. I can't seem to find a way to do this.
The function that has this is called from a button, and for now contains this :
evsInput.Text & " heure(s) à " & LookUp(typeEVS;TypeEVS = Dropdown1.SelectedText.Value;Coef) & " = " & 10*(evsInput.Text)*LookUp(typeEVS;TypeEVS = Dropdown1.SelectedText.Value;Coef)
evsInput is my text input, and I just find the coefficient I need in my excel table, and then want to calcuate the pay rate for this amount of time. For now i'm just multplying the text input by 10 (base pay rate) and the coefficient.
I'd love any help you got 🙂
