Forum Discussion

sudan's avatar
sudan
Regular Visitor
6 years ago

If condition between two time stamps

Hello Gurus - I want to write an conditional IF between two time timestamp and condition are

if created- Copy  <= " 8:00:00AM" AND Created- Copy  <= " 5:00:00PM" then "PST" Else "IST".

 

Need help ,

Regards

Sudan

 

 

 

 

 
Need Help

1 Reply

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Community Support
    6 years ago

    Hi,

     

    I think you can try this calculated column to easily reach your requirement:

    IST VS PST = IF('Table'[Created-Copy]>=TIME(8,0,0)&&'Table'[Created-Copy]<=TIME(17,0,0),"PST","IST")

    The result shows:

    Hope this helps.

     

    Best Regards,

    Giotto Zhi