Summary

The Excel TIME function builds a valid time value from separate hour, minute, and second inputs.

TIME is useful when time parts come from different cells, imported data, forms, or calculations and need to be turned into one usable Excel time value.

Syntax

=TIME(hour, minute, second)

All three arguments are required. Excel combines them into a single time value.

Arguments

• hour - The hour value.
• minute - The minute value.
• second - The second value.

TIME vs TIMEVALUE

These functions are related, but they solve different problems.

Use TIME when you already have the numeric pieces. Use TIMEVALUE when the time is still stored as text.

Using TIME

Microsoft documents that TIME returns a decimal number between 0 and about 0.99988426, which represents a time from midnight to 11:59:59 PM. The exact display depends on the cell format.

A useful detail is that TIME can handle oversized inputs. If the hour, minute, or second value is larger than the usual limit, Excel rolls the extra amount into the next unit. For example, extra minutes become additional hours.

This makes TIME a good choice for rebuilding times from calculations, normalizing imported data, or cleaning timestamps before using them in schedules or reports.

Example 1 - Build a Standard Time

The simplest use is building a time directly from numeric components.

=TIME(10,30,0)

This returns 10:30 AM as a valid Excel time value, which can then be formatted or used in later calculations.

Example 2 - Build a 24-Hour Time

TIME works naturally with 24-hour input values.

=TIME(22,45,0)

This returns 10:45 PM. That makes the function useful for shift schedules, system logs, and imported data that already uses 24-hour time.

Example 3 - Handle Minute Overflow

One of the most useful features of TIME is its rollover behavior.

=TIME(10,90,0)

Because 90 minutes equals 1 hour and 30 minutes, Excel returns 11:30 AM. This helps keep formulas simpler when time parts come from calculations.

Example 4 - Rebuild a Clean Time

TIME can rebuild a time after extracting parts from a larger timestamp.

=TIME(HOUR(B1),MINUTE(B1),0)

This is useful when you want to drop the seconds from a timestamp and keep only the hour and minute as a clean time value.

Conclusion Recap

• Summary: TIME builds a valid time value from hour, minute, and second inputs.
• Best use: It is ideal when the time parts are already available as numbers.
• Helpful feature: It automatically rolls oversized minutes and seconds into the next unit.
• Common uses: Schedules, imported data cleanup, and timestamp normalization.
• Difference from TIMEVALUE: TIME builds from numeric parts, while TIMEVALUE converts from text.
• Display tip: Format the result cell as a time so users see a readable clock value.