All functions / Date & Time
TIME
Builds a time from hours, minutes and seconds.
Syntax
=TIME(hour, minute, second)
Arguments
hour: 0-23.minute: 0-59.second: 0-59.
Example
=TIME(14, 30, 0) → 2:30 PM
All functions / Date & Time
Builds a time from hours, minutes and seconds.
=TIME(hour, minute, second)
hour: 0-23.minute: 0-59.second: 0-59.=TIME(14, 30, 0) → 2:30 PM