TIME

  • Updated

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

Sample Usage

TIME(10,40,49)
TIME(C5,C6,C7)

Syntax

TIME(hour, minute, second)

  • hour - The hour component of the time.
  • minute - The minute component of the time.
  • second - The seconds component of the time.

Examples

TIME(10,40,49) returns the time string 10:40:49 AM.
TIME(C5,C6,C7) returns the time string using the values in C5C6 and C7 as hours, minutes and seconds respectively.

Notes

  • The arguments must be numbers - if a string or a reference to a cell containing a string is provided, the #VALUE! error will be returned.
  • TIME recalculates numeric time values which fall outside of valid ranges. For example, TIME(25,0,0) returns a time string of 1:00 AM.
  • Decimal inputs will be truncated.