TIME

Returns the serial number of a particular time.


Date Value Formula Excel TimeStamp Formatted TimeStamp
Hour Minute Second
315=TIME(A1,B1,C1)0.135416666666666703:15:00
1315=TIME(A2,B2,C2)0.552083333333333413:15:00
151515=TIME(A3,B3,C3)0.635590277777777815:15:15
31530=TIME(A4,B4,C4)0.135763888888888903:15:30
151515=TIME(A5,B5,C5)0.635590277777777815:15:15
5=TIME(A6,B6,C6)0.208333333333333305:00:00
9150=TIME(A7,B7,C7)0.385416666666666709:15:00
915-1=TIME(A8,B8,C8)0.385405092592592609:14:59
13-14-15=TIME(A9,B9,C9)0.531770833333333312:45:45
00-1=TIME(A10,B10,C10)#NUM!#NUM!