Answered

Sum of Worked hours per day

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Let's suppose I work from 22:00 pm till 05:00 am from next day. That will result in 7 hours worked. This is all I got so far.

"Das 18:00 às 22:00: " & With(
 {
 diferencaHora: DateDiff(
 TimeValue(HourValue1.Selected.Value & ":" & MinuteValue1.Selected.Value),
 TimeValue(HourValue2.Selected.Value & ":" & MinuteValue2.Selected.Value),
 Minutes
 )
 },
 With(
 {
 resto: Mod(
 diferencaHora,
 60
 )
 },
 With(
 {
 ateAs22: DateDiff(
 Time(
 Value(HourValue1.Selected.Value),
 MinuteValue1.Selected.Value,
 0
 ),
 Time(
 Value(22),
 0,
 0
 ),Minutes
 )
 },
 With(
 {
 diferencaEstatica: Mod(
 ateAs22,
 60
 )
 },
 If(
 TimeValue(HourValue1.Selected.Value & ":" & MinuteValue1.Selected.Value) < Time(
 Value(22),
 0,
 0
 ) && TimeValue(HourValue2.Selected.Value & ":" & MinuteValue2.Selected.Value) < Time(
 Value(22),
 0,
 0
 ) && TimeValue(HourValue1.Selected.Value & ":" & MinuteValue1.Selected.Value) > Time(
 Value(18),
 0,
 0
 ) ,
 (diferencaHora - resto) / 60 & " horas e " & resto & " minutos trabalhados",
 If(
 TimeValue(HourValue1.Selected.Value & ":" & MinuteValue1.Selected.Value) < Time(
 Value(22),
 0,
 0
 ) && TimeValue(HourValue2.Selected.Value & ":" & MinuteValue2.Selected.Value) > Time(
 Value(22),
 0,
 0
 ) && TimeValue(HourValue1.Selected.Value & ":" & MinuteValue1.Selected.Value) > Time(
 Value(18),
 0,
 0 ),
 (ateAs22 - diferencaEstatica) / 60 & " horas " & diferencaEstatica & " minutos trabalhados",
 0
 )
 )
 )
 )
 )
)

In this code I don't calculate hours per day because all I get is a negative value

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

PowerRanger 3,458 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous Is HourValue1 a DropDown? Do you also specify a Start and End Date somewhere? Could you provide a screenshot of the app where it shows how you enter Start and End?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

The difference of days must be equals to one and If it is Equals to 1 than Sum the hours. But yes, it is a DropDown
Verified answer

PowerRanger 3,458 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous So your formular will look something like that:
DateDiff( DateValue3.SelectedDate + Time( Value(HourValue3.Selected.Value), Value(MinuteValue3.Selected.Value), 0 ), DateValue4.SelectedDate + Time( Value(HourValue4.Selected.Value), Value(MinuteValue4.Selected.Value), 0 ), Hours )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Really appreciate your help
PowerRanger 3,458 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous Full solution with DateRange check will be something like:
If( DateDiff( DateValue3.SelectedDate, DateValue4.SelectedDate, Days ) = 1, Text(DateDiff( DateValue3.SelectedDate + Time( Value(HourValue3.Selected.Value), Value(MinuteValue3.Selected.Value), 0 ), DateValue4.SelectedDate + Time( Value(HourValue4.Selected.Value), Value(MinuteValue4.Selected.Value), 0 ), Hours )), "Error" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.