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
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Kudoed Authors
Users online (2,410)