How to use an IF statement on a Time/Date column to automatically populate a new column?

Question

On my list, I have a Time/Date column named 'ActivityDate'. The format of this column is "mm/dd/yyyy hh:mm AM/PM"

I am trying to set up a new column called 'Result'.

If the time on 'ActivityDate' is past 9:00 AM, I want the 'Result' column's value to be 'LATE'.

If the time on 'ActivityDate' is before 9:00 AM, I want the 'Result' column's value to be 'ON TIME'.

I am quite familiar with Power Apps / Power Automate, but I have no idea how to set up a formula on sharepoint-column wise.

Please help.

Answer 1

Try using this formula for your calculated column:

=IF(TIME(HOUR([ActivityDate]),MINUTE([ActivityDate]),SECOND([ActivityDate])) > TIME(9,0,0), "Late", "ON TIME")

Documentation:

1. Introduction to SharePoint Formula and Functions
2. SharePoint Calculated Field Formula