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) | 0.135416666667 | 03:15:00 |
| 13 | 15 | | =TIME(A2,B2,C2) | 0.552083333333 | 13:15:00 |
| 15 | 15 | 15 | =TIME(A3,B3,C3) | 0.635590277778 | 15:15:15 |
| 3 | 15 | 30 | =TIME(A4,B4,C4) | 0.135763888889 | 03:15:30 |
| 15 | 15 | 15 | =TIME(A5,B5,C5) | 0.635590277778 | 15:15:15 |
| 5 | | | =TIME(A6,B6,C6) | 0.208333333333 | 05:00:00 |
| 9 | 15 | 0 | =TIME(A7,B7,C7) | 0.385416666667 | 09:15:00 |
| 9 | 15 | -1 | =TIME(A8,B8,C8) | 0.385405092593 | 09:14:59 |
| 13 | -14 | -15 | =TIME(A9,B9,C9) | 0.531770833333 | 12:45:45 |
| 0 | 0 | -1 | =TIME(A10,B10,C10) | #NUM! | #NUM! |