How do I convert the 'Created Date' field to a time-only format for comparison in a formula?

harryjohn

Hi everyone,
I'm working on a sheet that tracks form submissions, and I’d like to evaluate whether each entry was submitted on time. I’m using the 'Created Date' system column to capture when the form was submitted, but I only want to compare the time portion (not the full date). How can I extract just the time from the 'Created Date' field so I can use it in a formula to check if the submission was before or after 11:30 AM? I'm still learning formulas, so simple guidance would be appreciated! Thanks in advance.

=Chris Palmer

Hi @harryjohn

Something like this perhaps?

=TIME((RIGHT(Created@row, 8)))