Power Platform Community Forum Thread Details

Hi everyone, i am making an app that count the extra hours worked by some engineers but on weekends the hours value is 1.5, so i need to adapt this formula to decompose, for example, if it starts on a Friday at 10:00 p.m. and ends at 02:00 a.m. on Saturday, the total value of the hours should be 5 (2+3)

With(
        {
            wStart: dp_Fecha_Inicio_Solicitud.SelectedDate + Time(
                Value(dp_Hora_Inicio.Selected.Value);
                Value(dp_Min_Inicio.Selected.Value);
                0
            );
            wEnd: dp_Fecha_Fin_Solicitud.SelectedDate + Time(
                Value(dp_Hora_Final.Selected.Value);
                Value(dp_Min_Final.Selected.Value);
                0
            )
        };
        With(
            {
                wDiff: wEnd - wStart
            };
            Round(Abs(wDiff) * 24; 1)
        )
    );