I have a PowerApps form which contains an adjustable “Submission Date” field. Here is a screenshot to show what I mean:
I am trying to come up with a formula for a calculated column in SharePoint called “Submission Status” to determine whether or not the form was submitted during the day, which in my case would be between 9:30 AM to 5:00 PM (inclusive) on a weekday. I can get it to work for 9:00AM to 5:00PM, however I can’t get it to work with a schedule starting at exactly 9:30AM. I’m fairly new to SharePoint so I’m not sure how to account for those minutes.
For reference, this is the formula I’ve got that works for 9:00AM – 5:00PM :
=IF(OR(HOUR((Submission Date))>17,HOUR((Submission Date))<9),"Submitted after hours", IF(OR(TEXT((Submission Date),"dddd")="Saturday",TEXT((Submission Date),"dddd")="Sunday"),"Submitted on a weekend", IF(OR(HOUR((Submission Date))<=17,HOUR((Submission Date))>=9),"Submitted during the day")))
Any help would be appreciated