Excel Function

TIME

Builds a time from hour, minute, second.

TIME(hour, minute, second)

Arguments

hour

Required

Enter a numeric value.

minute

Required

Enter a numeric value.

second

Required

Enter a numeric value.

Practice Preview

Use TIME to return the result with these settings (Hour: 9, Minute: 30, Second: 0).

Example Table

#	ATask ID	BStart Date	CEnd Date	DNotes	EHoliday
2	T001	2026/03/01	2026/03/05	Standard task	2026/03/03
3	T002	2026/03/03	2026/03/10	Priority task	2026/03/06
4	T003	2026/03/05	2026/03/12	Standard task	2026/03/10
5	T004	2026/03/08	2026/03/14	Urgent task	2026/03/12
6
7
8

How to Use (Formula)

=TIME(9, 30, 0)

Result

09:30:00

Practice This Function

Start Function Practice Back to Function List

TIME FAQ

How do I use TIME in Excel?

Use TIME when you want to build a time from hour, minute, and second. Enter Hour, Minute, Second in that order, then add optional arguments when needed.

Where can I practice TIME?

Use the "Start Function Practice" button to jump straight into TIME drills.

What arguments does TIME use?

The main arguments are Hour, Minute, Second. Enter them in order.