The decimal number returned by TIME is a
value ranging from 0 (zero) to 0.99999999, representing the times from 0:00:00
(12:00:00 AM) to 23:59:59 (11:59:59 P.M.).
Syntax:
=TIME(hour, minute, second)
|
|
TIME Function
|
||
|
|
A
|
B
|
C
|
|
1
|
Serial_Number
|
3/20/2014 15:42
|
=NOW()
|
|
2
|
=HOUR(B10)
|
15
|
|
|
3
|
=MINUTE(B1)
|
42
|
|
|
4
|
=SECOND(B1)
|
21
|
|
|
5
|
=TIME(B2,B3,B4)
|
3:42 PM
|
|
