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.

1 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")


  1. Introduction to SharePoint Formula and Functions
  2. SharePoint Calculated Field Formula
  • Hi @dataKim, did you try this? Is it working for you? Commented Nov 3, 2022 at 7:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.