Time Interval

[Anonymous]

Hello Every one, 

I am new using power bi and need to cheek someting

I have a colum named "Delivery Time", and and two more called "Est_1" and "Est_2"

I need to know if the delivery time fits in the hours of Est 1 and est 2, for example

Delivery Time    Est 1       Est 2

12:00 am         10:00      13:00

In this case, my delivery time is in the allowed range, 

Is there a way to validate if the delivety time is between the other two??

Please I need help

[Ashish_Mathur · Accepted solution]

Hi,

Create this calculated column formula

=AND([Delivery Time]>=[Est 1],[Delivery Time]<=[Est 2])

Hope this helps.

[peymanrmt]

How do we calculate the time interval between two dates in hours, excluding the weekends and US holidays?