Skip to Content

TIME

Returns the decimal number for a particular time

Syntax

TIME(hour, minute, second)

Parameters

  • hour: Required. A number from 0 to 32767 representing the hour
  • minute: Required. A number from 0 to 32767 representing the minute
  • second: Required. A number from 0 to 32767 representing the second

Example

=TIME(14, 30, 0)
Returns: Time serial numberSince: Excel 2003