Skip to main content

TIME

Calculates the serial number which corresponds to the time specified by given hours, minutes and seconds

Syntax

=TIME(Hours, Minutes, Seconds)

Arguments

NameDescription
HoursA number which specifies hours
MinutesA number which specifies minutes
SecondsA number which specifies seconds

Return Value

A serial number value which corresponds to specified time.

Example

FunctionResultComment
=TIME(12, 0, 0)0.5The given time value represents 12:00 AM.