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.
Solved! Go to Solution.
@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!
@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?
Remember: Set the Format of the DatePicker to ShortDate.
Hope this helps!
Please remember to give a 👍 and accept the solution as it will help others in the future.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
199 | |
98 | |
58 | |
56 | |
52 |
User | Count |
---|---|
257 | |
161 | |
87 | |
79 | |
68 |