TIME() : extract the time from a date and time

In a formula column, the TIME() function displays the time of a date and time column. The result is a time.

The key point: the source column must include time. On a date-only column, without the Time option enabled, TIME() has nothing to extract.

Syntax

TIME(date_column)

# Parameter Description

1 date_column The date and time column to extract the time from.

For a date of 08-04-2022 15:30, the column returns 15:30.

TIME($Date)

Project 1 takes place at 15:30.

The source column does not include time

Enable the Time option on the source date column: without it, TIME() has nothing to extract.

The column output format is not appropriate

In the Options tab, check the field's output format. For details, see Output format options in the Formula column article.

To reformat the whole date and time rather than extract a single component.

Read more →

All available operators and functions, sorted by category.

Read more →