TIME

01:02:57 Returns the serial number of a particular time.
01:02:57 Hour: 3
01:02:57 Minute: 15
01:02:57 Second:
01:02:57 Formula: =TIME(A1,B1,C1)
01:02:57 Excel TimeStamp: 0.13541666666667
01:02:58 Formatted TimeStamp: 03:15:00
01:02:58
01:02:58 Hour: 13
01:02:58 Minute: 15
01:02:58 Second:
01:02:58 Formula: =TIME(A2,B2,C2)
01:02:58 Excel TimeStamp: 0.55208333333333
01:02:58 Formatted TimeStamp: 13:15:00
01:02:58
01:02:58 Hour: 15
01:02:58 Minute: 15
01:02:58 Second: 15
01:02:58 Formula: =TIME(A3,B3,C3)
01:02:58 Excel TimeStamp: 0.63559027777778
01:02:58 Formatted TimeStamp: 15:15:15
01:02:58
01:02:58 Hour: 3
01:02:58 Minute: 15
01:02:58 Second: 30
01:02:58 Formula: =TIME(A4,B4,C4)
01:02:58 Excel TimeStamp: 0.13576388888889
01:02:58 Formatted TimeStamp: 03:15:30
01:02:58
01:02:58 Hour: 15
01:02:58 Minute: 15
01:02:58 Second: 15
01:02:58 Formula: =TIME(A5,B5,C5)
01:02:58 Excel TimeStamp: 0.63559027777778
01:02:58 Formatted TimeStamp: 15:15:15
01:02:58
01:02:58 Hour: 5
01:02:58 Minute:
01:02:58 Second:
01:02:58 Formula: =TIME(A6,B6,C6)
01:02:58 Excel TimeStamp: 0.20833333333333
01:02:58 Formatted TimeStamp: 05:00:00
01:02:58
01:02:58 Hour: 9
01:02:58 Minute: 15
01:02:58 Second: 0
01:02:58 Formula: =TIME(A7,B7,C7)
01:02:58 Excel TimeStamp: 0.38541666666667
01:02:58 Formatted TimeStamp: 09:15:00
01:02:58
01:02:58 Hour: 9
01:02:58 Minute: 15
01:02:58 Second: -1
01:02:58 Formula: =TIME(A8,B8,C8)
01:02:58 Excel TimeStamp: 0.38540509259259
01:02:58 Formatted TimeStamp: 09:14:59
01:02:58
01:02:58 Hour: 13
01:02:58 Minute: -14
01:02:58 Second: -15
01:02:58 Formula: =TIME(A9,B9,C9)
01:02:58 Excel TimeStamp: 0.53177083333333
01:02:58 Formatted TimeStamp: 12:45:45
01:02:58
01:02:58 Hour: 0
01:02:58 Minute: 0
01:02:58 Second: -1
01:02:58 Formula: =TIME(A10,B10,C10)
01:02:58 Excel TimeStamp: #NUM!
01:02:58 Formatted TimeStamp: #NUM!
01:02:58