time
What Does It Do?
This function will convert three separate numbers to an actual time.
Syntax
=TIME(Hour,Minute,Second)
Formatting
The result will be shown as a time which can be formatted either as 12 or 24 hour style. If a normal number format is applied a decimal fraction is shown which represents the time as a fraction of the day.
| Hour | Minute | Second | Time | |
| 14 | 30 | 59 | 14:30:59 | =TIME(C4,D4,E4) |
| 14 | 30 | 59 | 2:30:59 PM | =TIME(C5,D5,E5) |
| 14 | 30 | 59 | 0.60485 | =TIME(C6,D6,E6) |