Notifications
Announcements
Buenas, necesito calcular las horas entre las fechas que aparecen arriba, la idea es calcular las horas extras de un empleado, he intentado muchas veces usar el datediff, pero no hay resultado, por favor, ayuda.
@tfernandez To get something like this,
Use this formula,
"Minutes: " & DateDiff(DateTimeValue(date1.SelectedDate & " " & hour1.Selected.Value &":" & minute1.Selected.Value), DateTimeValue(date2.SelectedDate & " " & hour2.Selected.Value &":" & minute2.Selected.Value), Minutes)
"Hours: " & DateDiff(DateTimeValue(date1.SelectedDate & " " & hour1.Selected.Value &":" & minute1.Selected.Value), DateTimeValue(date2.SelectedDate & " " & hour2.Selected.Value &":" & minute2.Selected.Value), Hours)
Remember: Set the Format of the DatePicker to ShortDate.
Hope this helps!
Hola!
Al parecer la formula sirve perfectamente, ahora el problema que tengo es que al darle play a mi aplicacióin no me muestra la información para probarla.
Cuando debiese mostrarse asÃ
¿Cupal podria ser el problema?
@tfernandez For some reason your controls are not visible. Check their visible property.
Please remember to give a 👍 and accept the solution as it will help others in the future.
Ecaxtamente, cambie la configuraci´´on y ya puede vers, sin embargo la formula no tuvo resultado.
Estare haciendo algo mal?
@tfernandez
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 796 Most Valuable Professional
Michael E. Gernaey 327 Super User 2025 Season 2
Power Platform 1919 268
