cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lmszy
New Member

Convert time to integer

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 🙂

1 ACCEPTED SOLUTION

Accepted Solutions
lmszy
New Member

Ok well i just found how to do it, just have to convert minutes into hours (mm/60) and then add the hours and converted minutes.

View solution in original post

1 REPLY 1
lmszy
New Member

Ok well i just found how to do it, just have to convert minutes into hours (mm/60) and then add the hours and converted minutes.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (6,438)