Scenario: To extract the time from a date field that returns both date and time on the Login Audit Trail.
Solution:
Navigate to Lists > Search > Saved Searches > New
Click Login Audit Trail
Click the Results tab
Field:
Add Formula (Text)
Formula field: TO_CHAR({date}, ‘HH:MI:SS’)
Name the Saved Search
Click Save & Run