TIME
Returns the serial number of a particular time.
| Date Value |
Formula |
Excel TimeStamp |
Formatted TimeStamp |
| Hour |
Minute |
Second |
| 3 | 15 | | =TIME(A1,B1,C1) | =TIME(A1,B1,C1) | =D1 |
| 13 | 15 | | =TIME(A2,B2,C2) | =TIME(A2,B2,C2) | =D2 |
| 15 | 15 | 15 | =TIME(A3,B3,C3) | =TIME(A3,B3,C3) | =D3 |
| 3 | 15 | 30 | =TIME(A4,B4,C4) | =TIME(A4,B4,C4) | =D4 |
| 15 | 15 | 15 | =TIME(A5,B5,C5) | =TIME(A5,B5,C5) | =D5 |
| 5 | | | =TIME(A6,B6,C6) | =TIME(A6,B6,C6) | =D6 |
| 9 | 15 | 0 | =TIME(A7,B7,C7) | =TIME(A7,B7,C7) | =D7 |
| 9 | 15 | -1 | =TIME(A8,B8,C8) | =TIME(A8,B8,C8) | =D8 |
| 13 | -14 | -15 | =TIME(A9,B9,C9) | =TIME(A9,B9,C9) | =D9 |
| 0 | 0 | -1 | =TIME(A10,B10,C10) | =TIME(A10,B10,C10) | =D10 |