TIME

Converts an hour, minute, and second into a time.

Sample Usage

TIME(11,40,59)

TIME(A2,B2,C2)

Syntax

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.

Notes

  • Inputs to TIME must be numbers - if a string or a reference to a cell containing a string is provided, the #VALUE! error will be returned.

  • TIME will silently recalculate numeric time values which fall outside of valid ranges. For example, TIME(25,0,0), which specifies the illegal hour 25, will create a time of 1:00 AM. Similarly, TIME(12,0,60), which specifies the illegal 61st second of a minute (:00 being the first second), will create a time of 12:01:00.

  • TIME will silently truncate decimal values input into the function, e.g. an hour of 12.75 will be interpreted as 12.

See Also

DATE: Converts a year, month, and day into a date.

Examples

Returns the time value from specified hours, minutes and seconds.

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
13498389699008301527
true
Search Help Center
true
true
true
true
true
35
false
false