TIME
Returns the serial number of a particular time.
Date & TimeDates & Time Calculations
What it does
Constructs a valid time from hour, minute, second numbers.
Syntax
TIME(hour, minute, second)
Arguments
hour(number) — 0-23.minute(number) — 0-59.second(number) — 0-59.
Examples
Create Time
Make 14:30:00.
FORMULA
=TIME(14, 30, 0)
RESULT
2:30 PM
SAMPLE DATA
| A | |
|---|---|
| 1 | Result |
| 2 | 0.604 |