Skip to main content
Version: Streamsheets 3.0

TIME

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

Syntax

=TIME(Hours, Minutes, Seconds)

Arguments

NameTypeDescription
HoursNumberA number between 0 and 23, which specifies hours
MinutesNumberA number between 0 and 59, which specifies minutes
SecondsNumberA number between 0 and 59, which specifies seconds

Return

TypeDescription
NumberA serial number value which corresponds to specified time.

Examples

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