Cellgrids Cellgrids
Home › Excel formulas › Date and Time › TIME

TIME Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

TIME is an Excel Date & Time function. Builds a time value from separate hour, minute, and second numbers.

TIME syntax

=TIME(hour, minute, second)

Arguments

When to use TIME

TIME is used in scheduling, deadline tracking, and reporting that spans specific date ranges.

Practice TIME online, free

Open the live Excel-style spreadsheet and try TIME yourself. No Excel install or sign-up needed to start.

Practice TIME now →

More Date & Time functions

Frequently asked questions

What does the TIME function do in Excel?

Builds a time value from separate hour, minute, and second numbers.

What is the syntax of TIME in Excel?

The syntax is =TIME(hour, minute, second). hour: The hour component of the time; minute: The minute component of the time; second: The second component of the time.

Where can I practice TIME online for free?

Open the free live spreadsheet on Cellgrids and try TIME yourself. No Excel install is needed and you can start without signing up.

All Excel formulas · Cheat sheet · Excel exercises · Date and Time functions · Excel case studies · Excel tutorials · Excel shortcuts