Calculate in hours opportunities

[AndreT]

during

Hi guys,
I am looking for a formula which would allow me to mark opportunities which arise  working hours.

I have already created created formula which shows me days of a week Day = FORMAT(MatchedTraders[createdAt Date],"DDDD")

I also have column with Created time

All I need is now a column which says:

In hours opportunities = if [Day] = Saturday or Sunday and [created_Time] 10am to 1pm, if [Day] =Monday to Friday and [created_Time] 8am to 6pm, "in hours", "outside working hours")

Does anyone know how to construct such calculation?

Many thanks in advance

Andre

[Zubair_Muhammad · Accepted solution]

@AndreT

Try this calculated Column

=
IF (
    OR (
        OR ( MatchedTraders[Day] = "Sunday", MatchedTraders[Day] = "Saturday" )
            && HOUR ( MatchedTraders[Created Time] ) >= 10
            && HOUR ( MatchedTraders[Created Time] ) < 13,
        MatchedTraders[Day] <> "Sunday"
            && MatchedTraders[Day] <> "Saturday"
            && HOUR ( MatchedTraders[Created Time] ) >= 8
            && HOUR ( MatchedTraders[Created Time] ) < 18
    ),
    "in hours",
    "outside working hours"
)

[AndreT]

Perfect it worked. Thank you!

[v-chuncz-msft]

@AndreT,

By the way, you may help accept solution. Your contribution is highly appreciated.