TIME

Date/Time Functions:
Function: TIME() - Returns the Excel serial number of a particular time.
(A1) Hour: 3
(B1) Minute: 15
(C1) Second:
Formula: =TIME(A1,B1,C1)
Excel TimeStamp: 0.13541666666667
Formatted TimeStamp: 03:15:00

(A2) Hour: 13
(B2) Minute: 15
(C2) Second:
Formula: =TIME(A2,B2,C2)
Excel TimeStamp: 0.55208333333333
Formatted TimeStamp: 13:15:00

(A3) Hour: 15
(B3) Minute: 15
(C3) Second: 15
Formula: =TIME(A3,B3,C3)
Excel TimeStamp: 0.63559027777778
Formatted TimeStamp: 15:15:15

(A4) Hour: 3
(B4) Minute: 15
(C4) Second: 30
Formula: =TIME(A4,B4,C4)
Excel TimeStamp: 0.13576388888889
Formatted TimeStamp: 03:15:30

(A5) Hour: 15
(B5) Minute: 15
(C5) Second: 15
Formula: =TIME(A5,B5,C5)
Excel TimeStamp: 0.63559027777778
Formatted TimeStamp: 15:15:15

(A6) Hour: 5
(B6) Minute:
(C6) Second:
Formula: =TIME(A6,B6,C6)
Excel TimeStamp: 0.20833333333333
Formatted TimeStamp: 05:00:00

(A7) Hour: 9
(B7) Minute: 15
(C7) Second: 0
Formula: =TIME(A7,B7,C7)
Excel TimeStamp: 0.38541666666667
Formatted TimeStamp: 09:15:00

(A8) Hour: 9
(B8) Minute: 15
(C8) Second: -1
Formula: =TIME(A8,B8,C8)
Excel TimeStamp: 0.38540509259259
Formatted TimeStamp: 09:14:59

(A9) Hour: 13
(B9) Minute: -14
(C9) Second: -15
Formula: =TIME(A9,B9,C9)
Excel TimeStamp: 0.53177083333333
Formatted TimeStamp: 12:45:45

(A10) Hour: 0
(B10) Minute: 0
(C10) Second: -1
Formula: =TIME(A10,B10,C10)
Excel TimeStamp: #NUM!
Formatted TimeStamp: #NUM!